和宝宝一起做的游戏大全,我的禽兽后爹,antialiasing
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好用
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
小白安装登录mysql-8.0.19-winx64的教程图解(新手必看)
Navicat连接MySQL时报10060、1045错误及my.ini位置问题
网友评论