Detailed explanation of MySql installation and login

Check if MySQL is already installed in Linux

 sudo service mysql start //Try to start the MySQL service

hint:

mysql: unrecongized service //Indicates that the system does not have MySQL

You need

 //Install MySQL server and core programs sudo apt-get install mysql-server
  //Install the MySQL client sudo apt-get install mysql-client

Verify sudo netstat -tap|grep mysql (note that there is a space before netstat and -tap)

Modify the configuration file (my.cnf) sudo gedit/etc/mysql/my.cnf

Practiced logging in and out of MySQL, using and viewing databases

//Start the MySQL service sudo service mysql start
   //
    mysql -u root

View the database show databases;

Connect to database using database name

View tables show tables;

Quit or exit

The above is the detailed explanation of MySql installation and login introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!