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

This article mainly shows you "how to install mysql commands under Centos", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to install mysql commands under Centos" this article.

Installation command under Centos

# yum list mysql

Install the mysql client

# yum install mysql

Www.2cto.com

# yum list mysql-server

Install the mysql server side

# yum install mysql-server

After installation, you need to start the mysql service. We can use the following two general methods:

1 、 service mysqld start

2 、 / etc/init.d/mysqld start

After startup, you need to create a root administrator for mysql:

# mysqladmin-u root password jereh223

Then we can enter the mysql command line by connecting to mysql as follows:

# mysql-u root-p

Www.2cto.com

Then you can add a new user.

Grant all on *. * to 'user'@'%' IDENTIFIED BY' password'

FLUSH PRIVILEGES

The above is all the contents of the article "how to install mysql commands under Centos". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.