Install MySql in Ubuntu

From Ubuntu Chinese

To install MySQL, run the following command at a terminal prompt:

 
Sudo apt-Get install mysql-Server
 

 
Sudo apt-Get install mysql-Client
 

 
Sudo apt-Get install php5-mysql
// Installing the php5-mysql is to connect PHP and MySQL
 

Once the installation is complete, the MySQL server should be started automatically. You can run the following command at a terminal prompt to check whether the MySQL server is running:

 
Sudo netstat-tap | grep MySQL
 

When you run this command, you can see a line similar to the following:

 
TCP 0 0 localhost. localdomain: MySQL *: * listen-
 

If the server cannot run properly, run the following command to start it:

 
Sudo/etc/init. d/MySQL restart
 

Go to MySQL

── ─ ── ─

Multiple methods for changing the root password of MySQL Method 1: use the set password command
Mysql-u Root
Mysql> set password for 'root' @ 'localhost' = PASSWORD ('newpass ');

Method 2: Use mysqladmin
Mysqladmin-u Root Password "newpass"
If the root user has set a password, use the following method:
Mysqladmin-u Root Password oldpass "newpass"

Method 3: Use update to directly edit the user table
Mysql-u Root
Mysql> use MySQL;
Mysql> Update user SET Password = PASSWORD ('newpass') where user = 'root ';
Mysql> flush privileges;

When the root password is lost
Mysqld_safe-Skip-grant-tables &
Mysql-u root MySQL
Mysql> Update user SET Password = PASSWORD ("new password") where user = 'root ';
Mysql> flush privileges;

 
Mysql-uroot-P
 

(Enter the MySQL Root Password)

Configure the MySQL administrator password:

 
Sudo mysqladmin-u Root Password newpassword