centos6.8安装mysql并配置远程登陆
程序员文章站
2022-08-10 08:47:21
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好用
推荐阅读
-
ubuntu16.10安装docker17.03.0-ce并配置国内源和加速器
-
Centos6.9安装vsftpd并配置多用户的方法
-
Mysql安装与配置调优及修改root密码的方法
-
mysql5.7.19 winx64安装配置方法图文教程(win10)
-
Mysql5.7 windows免安装版本 初始化配置
-
mysql 8.0.18 安装配置优化教程
-
macOS,安装+配置+激活:MySQL8.0 + Navicat Premium12
-
Mysql 5.7.19 免安装版配置方法教程详解(64位)
-
mysql 8.0.16 winx64安装配置方法图文教程
-
CentOS安装mysql5.7 及简单配置教程详解