MySql installation and login details

  • 2021-07-10 21:04:19
  • OfStack

Check whether MySQL is installed on the Linux system


   sudo service mysql start        // Try to open MySQL Services 

Hint:


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

You need to


   // Installation MySQL Server, core program 
        sudo apt-get install mysql-server
        // Installation MySQL Client 
        sudo apt-get install mysql-client

Verify sudo netstat-tapgrep mysql (note that netstat is preceded and 1 space is preceded-tap)

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

Practiced logging in and exiting MySQL, using and viewing databases


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

View the database show databases;

Connection database use database name

View table show tables;

Exit quit or exit


Related articles: