Linux复习资料——MySQL-client-5.6.50-1.el7.x86_64与MySQL-server-5.6.50-1.el7.x86_64包安装MySQL全过程
2023-09-14 09:14:16 时间
下载地址:https://download.csdn.net/download/feng8403000/85020526
目录
第一步,上传到Linux的/root下
步骤二安装必备内容
systemctl stop firewalld
yum install net-tools -y
yum install perl* -y
内容比较多,得下载一会。
步骤三、移除不必要内容
yum remove mysql-libs -y
步骤四、安装MySQL
rpm -ivh MySQL-server-5.6.50-1.el7.x86_64.rpm
rpm -ivh MySQL-client-5.6.50-1.el7.x86_64.rpm
步骤五、my.cnf编辑·方便无密码登录
vi /usr/my.cnf
第五行插入内容
skip-grant-tables
键盘输入【ESC】+【:wq】进行保存
步骤六、启动MySQL
systemctl restart mysql
步骤七、登录MySQL
mysql -u root -p
由于没有密码,直接按回车即可
步骤八、修改MySQL密码
update mysql.user set password=PASSWORD('Qwe159753') where User='root';
flush privileges;
如果出现问题可以通过如下方式修改:
set password = password('Qwe159753');
flush privileges;
步骤九、重新登录MySQL
输入exit退出MySQL
exit
再次登录。刚才改的【Qwe159753】
mysql -u root -p
步骤十、配置外网链接
查看是否可以外链接
select host from mysql.user where user ='root';
显示的是【%】所以可以外链接,直接【flush privileges;】刷新权限就行 ,否则执行以下命令:
use mysql;
update user set host="%" where user="root";
flush privileges;
相关文章
- Mysql远程连接数据库报错排查:pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on '**.**.**.**' (timed out)")
- Mysql授权允许远程访问解决Navicat for MySQL连接mysql提示客户端不支持服务器请求的身份验证协议;考虑升级MySQL客户端
- 【MySQL】解决mysql的 1594 错误
- Linux - mysql 异常:登录不上mysql数据库
- navcat导入mysql.sql出现:2006, 'MySQL server has gone away'
- XtraBackup出现 Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- PHP+MySQL代码部署在Linux(Ubuntu)上注意事项
- MySQL配置文件mysql.ini参数详解、MySQL性能优化
- linux下mysql下载安装
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (
- connection to dat Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- MySQL高可用性之Keepalived+Mysql(双主热备)
- CentOS下httpd下php 连接mysql 本机可以,外网报错Could not connect: Can't connect to MySQL server on '127.0.0.1' (13)2003 原因解析
- mysql启动时报错:Starting MySQL... ERROR! The server quit without updating PID file (/opt/mysql/data/mysql.pid) 的解决方法
- Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
- Mysql 如果有多个可选条件怎么加索引_MySQL|mysql-索引
- Starting MySQL. ERROR! The server quit without updating PID file (/data/mysql/mysql.pid).
- [转]2006 MySQL server has gone away错误,最大值溢出解决办法 mysql max_allowed_packet 查询和修改
- Starting MySQL ERROR! Couldn‘t find MySQL server (/usr/local/mysql/bin/mysqld_safe)
- MySQL Study之--Mysql无法启动“mysql.host”
- L75.linux命令每日一练 -- 第11章 Linux系统管理命令 -- lsof和uptime
- L62.linux命令每日一练 -- 第九章 Linux进程管理命令 -- strace和ltrace
- L41.linux命令每日一练 -- 第七章 Linux用户管理及用户信息查询命令 -- userdel和groupadd
- 解决ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- mysql select into outfile默认文件保存路径是C:ProgramDataMySQLMySQL Server 8.0Data
- MySQL远程连接报错2003-cant connection to mysql server on ‘IP’(10061 unknown error)
- Mysql之加密连接mysql_ssl_rsa_setup
- 【最全】linux服务器上安装Mysql