Linux下安装MySQL-devel-5.5.25

最新推荐文章于 2022-04-11 08:58:50 发布

原创最新推荐文章于 2022-04-11 08:58:50 发布 · 905 阅读

1 ·

CC 4.0 BY-SA版权

本文为博主收集整理 or 原创，觉得本文不错请素质三连(点赞、评论、收藏)，您的支持是我写下去的动力，如若侵权请联系删除。O(∩_∩)O~

CentOS_7 专栏收录该内容

64 篇文章

订阅专栏

本文详细介绍了如何在Linux操作系统中安装MySQL-devel-5.5.25，包括必要的依赖管理、源列表更新和安装步骤，为开发人员提供MySQL开发环境。

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

//系统
# cat /etc/redhat-release 
CentOS Linux release 7.7.1908 (Core)
# uname -r
3.10.0-1062.9.1.el7.x86_64

//查看本机是否已经安装mysql或mariadb
# rpm -qa|grep -i mysql
# rpm -qa|grep -i mariadb
//如果已经安装则卸载： 
# yum -y remove mysql mysql-server mysql-libs* compat-mysql51
# yum -y remove mariadb-libs mariadb mariadb-server
//rpm进行安装
# rpm -ivh MySQL-devel-5.5.25a-1.linux2.6.x86_64.rpm
# rpm -ivh MySQL-server-5.5.25a-1.linux2.6.x86_64.rpm
# rpm -ivh MySQL-client-5.5.25a-1.linux2.6.x86_64.rpm
//如果yum可用，也可以使用yum进行安装，yum安装的好处是自己解决相关依赖
# yum -y install MySQL-devel-5.5.25a-1.linux2.6.x86_64.rpm
# yum -y install MySQL-server-5.5.25a-1.linux2.6.x86_64.rpm
# yum -y install MySQL-client-5.5.25a-1.linux2.6.x86_64.rpm

//设置好 /etc/my.cnf (后附)
# chown mysql:mysql /etc/my.cnf

//启动mysql
# /etc/init.d/mysql start
//或
# systemctl start mysql
//检查MySQL端口
# lsof -i:3306

//设置mysql密码
# /usr/bin/mysqladmin -u root password 'yourpasswd'
//尝试登陆mysql
# mysql -uroot -p‘yourpasswd’
//登陆成功后开放远程登录权限
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'set-passwd' WITH GRANT OPTION;
mysql> 
//退出mysql
mysql> quit;

// my.cnf示例
# grep -v "#" /etc/my.cnf
============分割线============
[client]
port        = 3306
socket      = /var/lib/mysql/mysql.sock
default-character-set=utf8


[mysqld]
port        = 3306
socket      = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 4M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
thread_concurrency = 8
character_set_server=utf8mb4
init_connect = 'SET NAMES utf8mb4'
max_connections=1024


log-bin=mysql-bin

binlog_format=mixed

server-id   = 12


innodb_data_home_dir = /var/lib/mysql	##如果设置了datadir则需要与之相同
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql
innodb_log_file_size = 64M
innodb_log_files_in_group= 2

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout
============分割线============