Ubuntu mysql

To install mysql database in the ubuntu:

    1. sudo apt-get install mysql-server

  2. apt-get isntall mysql-client

  3.  sudo apt-get install libmysqlclient-dev

in the first step it will asked you to enter the root password and you should remember it, or can not login the mysql database.

2. to make sure you have installed mysql database successfully you should enter

  "sudo netstat -tap|grep mysql " in the Terminal to make sure that

3. log in mysql use this command   "mysql -u root -p "

   -u for chose the username to log in -p for the password of the user 

4. use the command "show databases;" can show the databases in mysql database

5 use the command "use databasename" to select the database and "show tables;" show the tables in the database.

 

posted @ 2015-07-01 22:57  someOneHan  阅读(92)  评论(0编辑  收藏  举报