Using MySQL in Linux

One.

1. Check if MySQL is installed on the Linux system and the command is:

sudo service MySQL start

If the mysql:unrecognized service is indicated, there is no MySQL in the system and needs to be installed.

2.Ubuntu Linux installation configuration mysql: The simplest way to install MySQL on Ubuntu is to install it online

The command is: sudo apt-get install mysql-server #安装MySQL服务端, core program

sudo apt-get install mysql-client #安装MySQL客户端

During installation, you will be prompted to confirm Yes, set the root user password (can be modified later), etc.

After the installation is complete, verify that the command is installed successfully: sudo netstat-tap | grep MySQL

3. After the installation is successful, you can modify the MySQL configuration file (my.cnf) with a gedit according to your needs, the command is:

sudo gedit/etc/mysql/my.cnf

At this point, MySQL in Linux has been installed and configured to complete.

Two.

1. Turn on MySQL

Start Mysql:sudo service MySQL start

Login with root: Mysql-u root-p

2. Other operational commands see: http://www.cnblogs.com/zhou0000/p/8287520.html

Ps:1. The basic operation commands for MySQL in Windows and Linux are generally no different.

2. Note that the semicolon is written at the end of each statement;

Using MySQL in Linux