Install MySQL under Ubuntu and use

First, in the Ubuntu terminal input

sudo apt-get install Mysql-server

Second, in the installation to set the root password, you can input, but must remember.

Third, after installation can use command detection is successful installation

sudo netstat-tap|grep MySQL

Iv. log in with root MySQL input

sudo mysql-u root-p

Explain:

-U: Specify that you want to use that database user login, only install the root password when we only know that there is root user, so use root

-P: Specify password, do not enter the password directly after-p, invalid, command input regret automatically let you enter the password

V. Users viewing the database

Use user;

Update user Set host = '% ' where user = ' root ';

Select Host,user from user;

Explanation: means to go to the user database to view, change the host to% because if you do not modify the default to local host, other IP logins will report an error that does not allow access.

Vi. Change Configuration Let Telnet

sudo vim/etc/mysql/my.cnf

Use the # symbol to comment out bind_address = 127.0.0.1

Seven, restart the MySQL service, because the configuration changed

Sudo/etc/init.d/mysql restart

Eight, log on to other computers, I use NAVICAT login on Windows

Install MySQL under Ubuntu and use