centos6.8安装mysql并配置远程登陆
2018-06-18 01:07:28来源:未知 阅读 ()
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好用
标签:
版权申明:本站文章部分自网络,如有侵权,请联系:west999com@outlook.com
特别注意:本站所有转载文章言论不代表本站观点,本站所提供的摄影照片,插画,设计作品,如需使用,请与原作者联系,版权归原作者所有
上一篇:数据库事务的四大特性以及隔离级别
下一篇:优化mysql
- MySQL replace函数怎么替换字符串语句 2020-03-09
- PHP访问MySQL查询超时怎么办 2020-03-09
- mysql登录时闪退 2020-02-27
- MySQL出现1067错误号 2020-02-27
- mysql7.x如何单独安装mysql 2020-02-27
IDC资讯: 主机资讯 注册资讯 托管资讯 vps资讯 网站建设
网站运营: 建站经验 策划盈利 搜索优化 网站推广 免费资源
网络编程: Asp.Net编程 Asp编程 Php编程 Xml编程 Access Mssql Mysql 其它
服务器技术: Web服务器 Ftp服务器 Mail服务器 Dns服务器 安全防护
软件技巧: 其它软件 Word Excel Powerpoint Ghost Vista QQ空间 QQ FlashGet 迅雷
网页制作: FrontPages Dreamweaver Javascript css photoshop fireworks Flash