centos7.2 环境下 mysql-5.1.73 安装配置

时间:2023-03-10 06:36:17
centos7.2 环境下  mysql-5.1.73 安装配置
安装mysql,安装前准备
如果mysql用户不存在,那么添加mysql用户 groupadd mysql
useradd -g mysql mysql mysql编译安装
tar -zxvf mysql-5.1.73.tar.gz
cd mysql-5.1.73 yum install ncurses ncurses-devel
./configure '--prefix=/usr/local/mysql' '--without-debug' '--with-charset=utf8' '--with-extra-charsets=all' '--enable-assembler' '--with-pthread' '--enable-thread-safe-client' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--with-big-tables' '--with-readline' '--with-ssl' '--with-embedded-server' '--enable-local-infile' '--with-plugins=innobase' make
make install 到此mysql就安装到了/usr/local/mysql路径下,下面开始mysql的配置工作
安装mysql选项文件 cp support-files/my-medium.cnf /etc/my.cnf
cp -r support-files/mysql.server /etc/init.d/mysqld
/sbin/chkconfig --del mysqld
/sbin/chkconfig --add mysqld 配置权限表
chown -R mysql:mysql /usr/local/mysql
/usr/local/mysql/bin/mysql_install_db --user=mysql 启动mysql
给/etc/init.d/mysql 执行权限,然后运行
chmod a+wrx /etc/init.d/mysql
/etc/init.d/mysqld start mysql初始化配置:
包括密码设置等
export PATH=/usr/local/mysql/bin:$PATH
/usr/local/mysql/bin/mysql_secure_installation
 
在弹出的对话框中要求输入密码:
Enter current password for root (enter for none):
默认打回车,然后重新设置root密码: Set root password? [Y/n] y Disallow root login remotely? [Y/n] n Remove test database and access to it? [Y/n] n Reload privilege tables now? [Y/n] y 至此,Mysql运行成功