2010年9月7日 星期二

install mysql server on ubuntu

#apt-get update
#apt-get upgrade
update and upgrade the current os packages

#apt-get install mysql-server mysql-client
install mysql-server and client package

#mysql -u root -p
mysql>select version();

confirm the installion version of mysql

mysql>show databases;
show all databases you can access with your privileges;

mysql>use mysql;
use mysql database;

mysql>show tables;
show all tables with this database mysql

沒有留言:

張貼留言