Ubuntu install MySQL

Use Ubuntu10.04lts to install the MySQL steps as follows:

1. Install database: sudo apt-get install Mysql-server

The password needs to be set during installation.

2. Install the client: sudo apt-get install mysql-client

3. Login Mysql:mysql-u root-p

4. configuration file:/etc/mysql/my.cnf

A. Set remote access: Bind-address = 127.0.0.1 in 127.0.0.1 to native IP, which enables the database to support network remote access. After Setup is complete, restart the MySQL service: service mysql restart

B. Database on/off/restart, etc.:/etc/init.d/mysql [Start|stop|restart|reload|force-reload|status]

5. Exit the database: Exit

6. Uninstall mySQL:

A. Delete MySQL

1sudo apt-Get Autoremove--Purge MySQL-server
2 sudo apt- get remove mysql- server
3 -get autoremove mysql-server
4 -get remove mysql-common (very important)

In fact, some of the above is redundant, it is recommended to follow the order
B. Cleaning up residual data
Dpkg -l | grep ^RC| awk '{print $}' | sudo xargs dpkg -P

Ubuntu install MySQL