ubuntu16.04系统彻底卸载mysql,并源码免编译重装MySQL的步骤
2023-09-11 14:18:55 时间
今天的总结
ubuntu上彻底卸载MySQL或重新安装 https://www.jianshu.com/p/974b33873bca #查看是否存在mysql服务 service mysql status #查看安装了MySQL的相关软件包 dpkg --get-selections | grep mysql #卸载MySQL apt-get remove --purge mysql-* #清除本地残留文件 apt autoclean #清除无用依赖包(可选) apt autoremove #删除MySQL残留文件 rm -rf /etc/mysql /var/lib/mysql 免编译安装MySQL的方法 安装必要的依赖包 apt-get install libaio1 添加mysql用户 解压MySQL安装包 [root@localhost ~]# groupadd mysql [root@localhost ~]# useradd -r -g mysql -s /bin/false mysql [root@localhost ~]# mkdir -p /data [root@localhost ~]# cd /data [root@localhost data]# tar zxf mysql-5.7.23-linux-glibc2.12-x86_64.tar.gz [root@localhost data]# ln -s mysql-5.7.23-linux-glibc2.12-x86_64 mysql [root@localhost data]# 建立存放日志等目录 cd /data/mysql-5.7.23-linux-glibc2.12-x86_64/ mkdir logs binlogs run 删除旧配置文件 rm -rf /etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf 新增MySQL的配置文件/etc/my.cnf cat > /etc/my.cnf << EOF [client] default-character-set = utf8mb4 port= 3306 socket= /data/mysql/run/mysql.sock [mysql] default-character-set = utf8mb4 prompt = " \u@\h \R:\m:\s [\d]> " no-auto-rehash socket= /data/mysql/run/mysql.sock [mysqld] character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci character-set-client-handshake = FALSE server-id = 3306 user= mysql port= 3306 basedir= /data/mysql datadir= /data/mysql/data socket= /data/mysql/run/mysql.sock pid-file = /data/mysql/run/mysqld.pid skip_name_resolve = 1 open_files_limit = 65535 back_log = 1024 max_connections = 1024 log-error = /data/mysql/logs/mysql-error.log EOF 初始化MySQL [root@localhost data]# cd /data/mysql [root@localhost mysql]# mkdir mysql-files [root@localhost mysql]# chown mysql:mysql mysql-files [root@localhost mysql]# chmod 750 mysql-files [root@localhost mysql]# chown -R mysql:mysql . [root@localhost mysql]# bin/mysqld --initialize --user=mysql --basedir=/data/mysql --datadir=/data/mysql/data [root@localhost mysql]# bin/mysql_ssl_rsa_setup --datadir=/data/mysql/data ubuntu的unit file路径/lib/systemd/system cat > /lib/systemd/system/mysqld.service << EOF [Unit] Description=MySQL Server Documentation=man:mysqld(8) Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html After=network.target After=syslog.target [Install] WantedBy=multi-user.target [Service] User=mysql Group=mysql Type=forking PIDFile=/data/mysql/run/mysqld.pid # Disable service start and stop timeout logic of systemd for mysqld service. TimeoutSec=0 # Execute pre and post scripts as root PermissionsStartOnly=true # Needed to create system tables #ExecStartPre=/usr/bin/mysqld_pre_systemd # Start main service ExecStart=/data/mysql/bin/mysqld --daemonize --pid-file=/data/mysql/run/mysqld.pid $MYSQLD_OPTS # Use this to switch malloc implementation EnvironmentFile=-/etc/sysconfig/mysql # Sets open_files_limit LimitNOFILE = 65535 Restart=on-failure RestartPreventExitStatus=1 PrivateTmp=false EOF 配置MySQL环境变量 echo "export PATH=$PATH:/data/mysql/bin" >> /etc/profile source /etc/profile 启动与开机启动MySQL systemctl daemon-reload systemctl start mysqld.service systemctl enable mysqld.service systemctl is-enabled mysqld 用临时密码登录并修改临时密码 [root@localhost ~]# grep 'temporary password' /data/mysql/logs/mysql-error.log 2018-09-24T07:54:08.055154Z 1 [Note] A temporary password is generated for root@localhost: p=lXlKKrg4GJ [root@localhost ~]# mysql -urrott -p "p=lXlKKrg4GJ" mysql shell > alter user root@'localhost' identified by 'root12#$'; mysql shell > \q
相关文章
- MySQL 当记录不存在时插入(insert if not exists)
- MySQL索引背后的数据结构及算法原理
- PHP Mysql-创建数据表
- MySQL查看库中所有表的大小和记录数
- Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ (2)
- Golang 用go-sql-driver 调用MySQL存储过程时的问题排查
- 关于Mysql 查询所有表的实时记录用于对比2个MySQL 库的数据是否异步
- Mysql 数据库时间与系统时间不一致问题排查
- 如何在 MySQL 中存储 emoji ?
- http://lists.mysql.com/mysql
- 【MySQL进阶-10】mysql语句的执行流程以及集群的高可用
- 【mysql问题】解决2003-Can‘t connect to MySQL server on ‘ ‘(10060“Unknown error“)
- Mysql的安全配置向导命令mysql_secure_installation
- 《PHP和MySQL Web开发从新手到高手(第5版)》一一2.6 将数据插入到表中
- 基于JSP+MySQL实现用户注册登录及短信发送功能【100010145】
- mac ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- 使用navicat连接mysql连接错误:Lost connection to Mysql server at 'waiting for initial communication packet'
- Mysql有用的面试题
- Mysql 5.7源码编译启动 报error问题:The server quit without updating PID file (/data/data_mysql/mysql.pid).
- MYSQL导入csv类型的数据出现The MySQL server is running with the --secure-file-priv option
- mysql的IFNULL()函数FLOOR(),ROUND()函数
- python操作mysql数据库系列-操作MySql数据库(二)
- 利用Java针对MySql封装的jdbc框架类 JdbcUtils 完整实现(包含增删改查、JavaBean反射原理,附源码)
- 【系统运维】linux系统下源码包安装Mysql数据库
- mysql—MySQL数据库中10位时间戳转换为标准时间后,如何对标准时间进行加减X天处理
- Mysql依赖库Boost的源码安装,linux下boost库的安装
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- 【MySQL】mysql更换root密码,全网唯一有用!
- (5.5)mysql高可用系列——MySQL半同步复制(实践)
- (3.9)mysql基础深入——mysqld 配置文件与参数加载过程源码分析【待写】
- (2.4)Mysql之SQL基础——下载与使用测试库
- Mysql 插入 path 插入不进去值
- 同步mysql部分表数据到docker容器中的mysql数据库供其他程序使用,附实际例子源码和镜像