Illustration of the method of installing MySQL through SSH on CentOS VPS

Enter yum install mysql-server

Press Y to continue

Installation is complete, set boot Mysql, enter chkconfig-- levels 235 mysqld on

Then start tomcat and type service mysqld start

After startup, log in to MYsql to set the password

Enter set password for 'root'@'localhost' = password (' 12345678'); to set the password

At this point, the mysql installation is complete! Then create the database, first view the database with show databases;

Then use the create database database name; to create the database

Use the grant all privileges on database name. * to root@localhost identified by 'password'; assign users to the database you just created

The superuser root is assigned here, and the red area below is the database name.

Summary

The above is the illustration of the method of installing MySQL through SSH on CentOS VPS introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave a message for me, and the editor will reply to you in time. Thank you very much for your support to the website!