A preliminary study of MySQL

operating system ：ubuntu

1. install MySQL

    a. install MySQL Server side 、 Core program commands ：sudo apt-get install mysql-server

    b. install MySQL Client commands ：sudo apt-get install mysql-client

    c. Verify that the command is installed and started successfully ：sudo netstat -tap | grep mysql

    d.( If necessary, ） modify MySQL Profile command ：sudo gedit /etc/mysql/my.cnf

2. The development of preparation ：

    a. open MySql The service command ：sudo service mysql start

    b. Use root User login command （ The password is empty. ）：mysql -u root

        b1. The password is not empty ：mysql -u root -p

3. New database command

    a.（ Get into mysql After operation ࿰