Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to install MySQL on CentOS VPS through SSH" related knowledge, editor through the actual case to show you the process of operation, the method of operation is simple and fast, practical, I hope that this "how to install MySQL on CentOS VPS through SSH" article can help you solve the problem.

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.

This is the end of the introduction to "how to install MySQL through SSH on CentOS VPS". Thank you for reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.