Ubuntu Online installation MySQL (simple version)

1. Install MySQL server side

Command: sudo apt-get install Mysql-server

Prompt to set root password

2. Log in to MySQL

Command: sudo mysql-u root-p

-U on behalf of user name;-p for password

3. Using MySQL

1) Presentation Database

Command: show databases;

2) Use a database

command: Use XXX;

4. Set up remote login MySQL

1) Change the/ETC/MYSQL/MY.CNF profile, comment bind-address = 127.0.0.1 so that it can see the remote computer.

2) give other host permissions: Grant all privileges on * * to ' root ' @ '% ' identified by ' root ' with GRANT option;

3) Restart MySQL service: sudo restart MySQL

　　

　　

Ubuntu Online installation MySQL (simple version)