mysql 5.7.13安装与初步使用

最新推荐文章于 2022-12-17 23:13:59 发布

wuxidemo

最新推荐文章于 2022-12-17 23:13:59 发布

阅读量341

点赞数

CC 4.0 BY-SA版权

分类专栏： mysql

本文链接：https://blog.youkuaiyun.com/wuxidemo/article/details/51777574

mysql 专栏收录该内容

2 篇文章

订阅专栏

本文介绍在Ubuntu 14.04系统中安装MySQL Server 5.7.13的具体步骤，包括解压安装包、配置文件路径、解决密码错误问题及设置远程登录等关键操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

环境 ubuntu 14.04 64bit

软件 mysql-server_5.7.13-1ubuntu14.04_amd64.deb-bundle.tar

准备工作

tar xvf mysql-server_5.7.13-1ubuntu14.04_amd64.deb-bundle.tar

解压后文件列表:

libmysqlclient20_5.7.13-1ubuntu14.04_amd64.deb
libmysqlclient-dev_5.7.13-1ubuntu14.04_amd64.deb
libmysqld-dev_5.7.13-1ubuntu14.04_amd64.deb
mysql-client_5.7.13-1ubuntu14.04_amd64.deb
mysql-common_5.7.13-1ubuntu14.04_amd64.deb
mysql-community_5.7.13-1ubuntu14.04_amd64.changes
mysql-community-client_5.7.13-1ubuntu14.04_amd64.deb
mysql-community-server_5.7.13-1ubuntu14.04_amd64.deb
mysql-community-source_5.7.13-1ubuntu14.04_amd64.deb
mysql-community-test_5.7.13-1ubuntu14.04_amd64.deb
mysql-server_5.7.13-1ubuntu14.04_amd64.deb
mysql-testsuite_5.7.13-1ubuntu14.04_amd64.deb
参考官网文档http://dev.mysql.com/doc/refman/5.7/en/linux-installation-debian.html

1. 安装次序

sudo dpkg -i mysql-{common,community-client,client,community-server,server}_*.deb
安装完conf文件目录: /etc/mysql
可执行文件: /usr/bin  /usr/sbin
数据库文件:/var/lib/mysql

2. 如果密码出错
例如添加hadoop运行mysql -uhadoop -pxxx
sudo mysqld_safe --skip-grant-tables
mysql> use mysql;
mysql> grant all on *.* to root@'%' identified by 'yourpassword';
mysql> update user set User='hadoop' where Host='%';
mysql> update user set Host='localhost' where User='hadoop';
mysql> flush privileges;
mysql> exit;
mysql -uhadoop -pyourpassword即可正常运行

3. 开启远程登录
 sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf 
bind-address = 127.0.0.1注销
重启mysql服务 sudo service mysql restart
关闭mysql sudo service mysql stop
启动mysql sudo service mysql start