How to install MySQL via SSH on a CentOS VPS

Type yum install mysql-server

Press Y to continue

Installation is complete, set MySQL to start at boot, enter chkconfig --levels 235 mysqld on

Then start tomcat and enter service mysqld start

After the startup is complete, log in to MYsql and set the password

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

At this point, mysql is installed! Then create a database, first use show databases; to view the database

Then use create database 數據庫名; to create the database,

Use grant all privileges on 數據庫名.* to root@localhost identified by ' 密碼'; assign users to the newly created database

The super user root is assigned here, and the red area in the figure below is the database name.

Summarize

The above is the graphic method of installing MySQL through SSH on CentOS VPS 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!