How to install MySQL via SSH on CentOS VPS

Inputyum install mysql-server

Press y to continue

Installation completed , set to start mysql at boot, enter chkconfig --levels 235 mysqld on

and then start tomcat, enter service mysqld start

After startup, log in to mysql and set the password

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

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

and then use

create database database name; to create the database,

Use

grant all privileges on database name.* to root@localhost identified by 'password'; Assign a user to the newly created database

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

The above is the detailed content of How to install MySQL via SSH on CentOS VPS. For more information, please follow other related articles on the PHP Chinese website!