CentOS 7.x安装MySQL 5.5的详细步骤、基本配置及相关说明

最新推荐文章于 2022-03-30 13:20:32 发布

Simple-395

最新推荐文章于 2022-03-30 13:20:32 发布

阅读量692

点赞数

分类专栏： MySQL # CentOS 文章标签： MySQL DB CentOS

本文链接：https://blog.csdn.net/lpw_cn/article/details/93326315

版权

MySQL 同时被 3 个专栏收录

22 篇文章 4 订阅

订阅专栏

21 篇文章 0 订阅

订阅专栏

CentOS

17 篇文章 0 订阅

订阅专栏

背景

为什么还用5.5版本？以前笔者使用的是5.6版本，但是服务器内存只有1G，启动后使用了近半的内存。果断换5.5，真的是很节约资源啊。
只是个数据存储工具，在互联网行业，视图、触发器、存储过程这些统统用不到，别问我为什么！

详细步骤

解压

tar -xzvf mysql-5.5.62-linux-glibc2.12-x86_64.tar.gz -C /opt

安装

cd /opt/mysql-5.5.62 && scripts/mysql_install_db

启动方式

bin/mysqld_safe &

基础配置（密码、远程登录启用、删除测试库）

bin/mysql_secure_installation

附安装日志

Installing MySQL system tables...
190622 14:34:17 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
190622 14:34:17 [Note] ./bin/mysqld (mysqld 5.5.62) starting as process 25767 ...
OK
Filling help tables...
190622 14:34:17 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
190622 14:34:17 [Note] ./bin/mysqld (mysqld 5.5.62) starting as process 25774 ...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h host-name password 'new-password'

Alternatively you can run:
./bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd ./mysql-test ; perl mysql-test-run.pl

Please report any problems at http://bugs.mysql.com/