linux 下安装mysql 完整过程及可能问题

太过爱你忘了你带给我的痛 2021-09-25 07:28 319阅读 0赞

# 1. 首先卸载系统可能自带的 mysql #

# yum remove mysql

# 2.安装 ncurses 和 bison 和 gcc-c++ #

# yum update && yum -y install ncurses-devel bison gcc-c++

# 3.安装cmake #

# wget https://github.com/Kitware/CMake/releases/download/v3.14.0/cmake-3.14.0.tar.gz
    # tar -vxzf cmake-3.14.0.tar.gz -C /usr/local
    # cd /usr/local/cmake-3.14.0
    # ./configure
    # make 
    # make install
    查看 cmake 版本
    # cmake -version

# 4. 创建mysql组和用户 #

# groupadd mysql
    # useradd -g mysql mysql

# 5. 创建数据库目录及分配访问权限 #

# mkdir -p /opt/app/mysql
    # chown -R root:mysql /opt/app/mysql
    # mkdir -p /opt/app/mysql/data
    # chown -R mysql:mysql /opt/app/mysql/data

# 6. 编译安装mysql 下载mysql源码 #

# wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz
    # tar -vxzf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz -C /usr/local
    # cd /usr/local/mysql-5.7.18-linux-glibc2.5-x86_64
    # cmake -DCMAKE_INSTALL_PREFIX=/opt/app/mysql -DMYSQL_DATADIR=/opt/app/mysql/data -DSYSCONFDIR=/etc
    参数说明：
    -DCMAKE_INSTALL_PREFIX    //安装根目录
    -DINSTALL_DATADIR         //数据存储目录
    -DSYSCONFDIR              //配置文件(my.cnf)目录
    # make 
    # make install

# 7. 配置 mysql #

# cd /opt/app/mysql
    # cp ./support-files/my-default.cnf /etc/my.cnf 
    # vim /etc/my.cnf
    在 [mysqld] 段修改
    basedir = /opt/app/mysql
    datadir = /opt/app/mysql/data
    保存退出编辑。:wq（保存退出vim)

# 8. 初始化数据库 #

# cd /opt/app/mysql
    # ./scripts/mysql_install_db --basedir=/opt/app/mysql --datadir=/opt/app/mysql/data --defaults-file=/etc/my.cnf --user=mysql
    # cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
    # chmod 755 /etc/rc.d/init.d/mysqld
    # chkconfig --add mysqld

# 9. 设置启动脚本变量 #

# vim /etc/rc.d/init.d/mysqld
    basedir=/opt/app/mysql
    datadir=/opt/app/mysql/data
    保存退出。 :wq（保存退出vim)

# 10. 设置变量环境 #

# echo "PATH=$PATH:/opt/app/mysql/bin" >> /etc/profile （永久生效）
    # source /etc/profile 使配置文件立即生效
    # export PATH=$PATH:/opt/app/mysql/bin （当前生效）

# 11. 启动服务 #

# service mysqld start
    /etc/init.d/mysqld: line 46: /u/app/mysql: is a directory
    /etc/init.d/mysqld: line 47: /u/app/mysql/data: is a directory
    Starting MySQL.                                            [  OK  ]

# 12. 设置数据库管理员root密码 #

# mysqladmin -u root password 'xxxxxx'

# 13.设置root用户授权 可在任意机器登录 #

#mysql -u root -p 
    输入密码  此时密码不可见直接输入即可
    grant all privileges on *.* to 'root'@'%' identified by 'xxxxxx' with grant option;
    flush privileges;

# 出现问题解决 #

阿里云-linux-AlibabaCloud(AliyunLinux)-安装Mysql8.0.23 [https://blog.csdn.net/wr1013304035/article/details/114406637][https_blog.csdn.net_wr1013304035_article_details_114406637]

启动mysql报错mysqld\_safe error: log-error set to /var/log/mariadb/mariadb.log[https://blog.csdn.net/qq\_34218345/article/details/106951035][https_blog.csdn.net_qq_34218345_article_details_106951035]

MySql错误：Starting MySQL...The server quit without updating PID file[https://blog.csdn.net/u010227042/article/details/105126495][https_blog.csdn.net_u010227042_article_details_105126495]

ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘[https://blog.csdn.net/whowhowhoisimportant/article/details/111599804][https_blog.csdn.net_whowhowhoisimportant_article_details_111599804]

兄弟我就帮到这儿了，祝顺

\-------------------------------------------------- 懒懒的分隔线 --------------------------------------------------

自己玩玩 ，随便看看

[pygou.com][]

[https_blog.csdn.net_wr1013304035_article_details_114406637]: https://blog.csdn.net/wr1013304035/article/details/114406637
[https_blog.csdn.net_qq_34218345_article_details_106951035]: https://blog.csdn.net/qq_34218345/article/details/106951035
[https_blog.csdn.net_u010227042_article_details_105126495]: https://blog.csdn.net/u010227042/article/details/105126495
[https_blog.csdn.net_whowhowhoisimportant_article_details_111599804]: https://blog.csdn.net/whowhowhoisimportant/article/details/111599804
[pygou.com]: http://pygou.com