1.安裝MySQL 2.啟動MySQL 3.為MySQL設置密碼 a.進入資料庫 b.修改MySQL密碼為123 4.設置遠程登陸 5.重啟MySQL資料庫 吐槽一句 Centos比Ubuntu好用 ...
1.安裝MySQL
[root@localhost ~]# wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
[root@localhost ~]# yum install mysql-community-release-el6-5.noarch.rpm
[root@localhost ~]# yum install mysql-community-server
2.啟動MySQL
[root@localhost ~]# service mysqld start
--defaults-file argument to mysqld_safe when starting the server [ OK ] Starting mysqld: [ OK ] [root@localhost ~]#
3.為MySQL設置密碼
a.進入資料庫
[root@localhost ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.6.39 MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
b.修改MySQL密碼為123
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123'); Query OK, 0 rows affected (0.00 sec)
4.設置遠程登陸
mysql> grant all privileges on *.* to 'root'@'%' identified by '123' with grant option; Query OK, 0 rows affected (0.00 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) mysql>
5.重啟MySQL資料庫
[root@localhost ~]# service mysqld restart Stopping mysqld: [ OK ] Starting mysqld: [ OK ] [root@localhost ~]#
吐槽一句 Centos比Ubuntu好用