MySQL配置与启动

1.安装mysql

yum install mysql mysql-server

2.启动mysql

service mysqld start

3.配置mysql

/usr/bin/mysql_secure_installation

Set root password? [Y/n] Y
Remove anonymous users? [Y/n] Y
Disallow root login remotely? [Y/n] Y
Remove test database and access to it? [Y/n] Y
Reload privilege tables now? [Y/n] Y

4.连接mysql

mysql -uroot -pyourpassword

5.创建可以外部连接的用户

create user IDENTIFIED BY 'password'
posted @ 2018-01-29 14:06  wynnzen  阅读(77)  评论(0)  编辑  收藏  举报