做定制网站怎么样,创意网站建设设计,站长工具特级a免费,动画制作软件ae问题描述
最近安装了MYSQL8#xff0c;遇到了各种问题#xff0c;总体汇总一下#xff0c;凡是无法启动就是my.cnf和初始化的参数不匹配。
第一种
启动前设置了mysqld --initialize --usermysql --lower-case-table-names1#xff0c;my.cnf文件却没有修改就去启动。
第…问题描述
最近安装了MYSQL8遇到了各种问题总体汇总一下凡是无法启动就是my.cnf和初始化的参数不匹配。
第一种
启动前设置了mysqld --initialize --usermysql --lower-case-table-names1my.cnf文件却没有修改就去启动。
第二种
启动没有设置mysqld --initialize可以启动成功但是又停止了服务然后修改了my.cnf文件在文件中增加了lower-case-table-names1。
第三种
安装了不匹配的版本导致yum install mysql-server安装失败。
错误日志1
[rootiZuf6it0abhodk626wob0vZ ~]# sudo service mysqld start
Redirecting to /bin/systemctl start mysqld.service
Job for mysqld.service failed because the control process exited with error code. See systemctl status mysqld.service and journalctl -xe for details.
[rootiZuf6it0abhodk626wob0vZ ~]# journalctl -xe
10月 31 08:34:02 iZuf6it0abhodk626wob0vZ systemd[1]: Starting MySQL Server...
-- Subject: Unit mysqld.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysqld.service has begun starting up.
10月 31 08:34:03 iZuf6it0abhodk626wob0vZ systemd[1]: mysqld.service: main process exited, codeexited, status1/FAILURE
10月 31 08:34:03 iZuf6it0abhodk626wob0vZ systemd[1]: Failed to start MySQL Server.
-- Subject: Unit mysqld.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysqld.service has failed.
--
-- The result is failed.
10月 31 08:34:03 iZuf6it0abhodk626wob0vZ systemd[1]: Unit mysqld.service entered failed state.
10月 31 08:34:03 iZuf6it0abhodk626wob0vZ systemd[1]: mysqld.service failed.
10月 31 08:34:03 iZuf6it0abhodk626wob0vZ polkitd[567]: Unregistered Authentication Agent for unix-process:23264:394775943 (system bus name :1.15617, objec错误日志2
[rootiZuf6it0abhodk626wob0vZ ~]# sudo service mysqld start
Redirecting to /bin/systemctl start mysqld.service
Job for mysqld.service failed because the control process exited with error code. See systemctl status mysqld.service and journalctl -xe for details.
[rootiZuf6it0abhodk626wob0vZ ~]# journalctl -xe
-- Unit mysqld.service has begun starting up.
10月 31 08:32:20 iZuf6it0abhodk626wob0vZ systemd[1]: mysqld.service: main process exited, codeexited, status1/FAILURE
10月 31 08:32:20 iZuf6it0abhodk626wob0vZ systemd[1]: Failed to start MySQL Server.
-- Subject: Unit mysqld.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysqld.service has failed.
--
-- The result is failed.
10月 31 08:32:20 iZuf6it0abhodk626wob0vZ systemd[1]: Unit mysqld.service entered failed state.
10月 31 08:32:20 iZuf6it0abhodk626wob0vZ systemd[1]: mysqld.service failed.
10月 31 08:32:20 iZuf6it0abhodk626wob0vZ polkitd[567]: Unregistered Authentication Agent for unix-process:21164:394765598 (system bus name :1.15615, objec
10月 31 08:32:20 iZuf6it0abhodk626wob0vZ sshd[21248]: pam_unix(sshd:auth): authentication failure; logname uid0 euid0 ttyssh ruser rhost120.55.40.20
10月 31 08:32:20 iZuf6it0abhodk626wob0vZ sshd[21248]: pam_succeed_if(sshd:auth): requirement uid 1000 not met by user root
10月 31 08:32:22 iZuf6it0abhodk626wob0vZ sshd[21248]: Failed password for root from 120.55.40.20 port 50908 ssh2
10月 31 08:32:22 iZuf6it0abhodk626wob0vZ sshd[21248]: Received disconnect from 120.55.40.20 port 50908:11: Bye Bye [preauth]
10月 31 08:32:22 iZuf6it0abhodk626wob0vZ sshd[21248]: Disconnected from 120.55.40.20 port 50908 [preauth]卸载教程
# ------ 卸载mysql
rpm -qa | grep mariadb
rpm -e --nodeps mariadb-libs
mysqladmin -V
# 查看已安装的mysql安装包参照下面的截图
rpm -qa|grep mysql# 使用如下指令将搜索到的mysql安装包全部卸载
rpm -e --nodeps mysql-community-client-plugins-8.0.35-1.el7.x86_64
rpm -e --nodeps mysql-community-client-plugins-8.0.35-1.el7.x86_64
rpm -e --nodeps mysql-community-server-8.0.35-1.el7.x86_64
rpm -e --nodeps mysql-community-common-8.0.35-1.el7.x86_64
rpm -e --nodeps mysql-community-libs-8.0.35-1.el7.x86_64
rpm -e --nodeps mysql-community-icu-data-files-8.0.35-1.el7.x86_64
rpm -e --nodeps mysql80-community-release-el7-1.noarch
rpm -e --nodeps mysql-community-client-8.0.35-1.el7.x86_64# 删除配置文件
rm -vf /etc/my.cnf.rpmsave
# 删除日志文件
rm -vf /var/log/mysqld.log
# 查看并删除其他残留文件
find / -name mysql
# 依次删除
rm -rf 对应路径
# ------ 卸载mysql
安装教程 # ------ 安装mysql#移除yum缓存
yum clean packages# 如果失败不需要关注继续向下
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022sudo yum install https://repo.mysql.com/mysql80-community-release-el7-1.noarch.rpm
sudo yum install mysql-server# 查看安装的版本
mysqladmin --version
# 初始化mysql使用mysql系统用户以安全模式为mysql的root用户生成临时密码第一次登录后要立马修改。
# 这里一定要注意
# 0 --大小写敏感。(UnixLinux默认)
# 1 --大小写不敏感。(Windows默认) 创建的库表时
# 2 --大小写不敏感(OS X默认) 创建的库表将原样保存在磁盘上
mysqld --initialize --usermysql --lower-case-table-names1
# 然后修改/etc/my.cnf文件中增加lower-case-table-names1否则mysql无法启动
# 然后在启动mysql# 查看临时密码
cat /var/log/mysqld.log
# 解锁root账户避免requirement uid 1000 not met by user root
passwd -u rootsudo service mysqld start
service mysqld status# 默认没有密码
mysql -uroot -p
# 直接回车然后输入刚才查看的密码 E-nlpd,k7iXALTER USER rootlocalhost IDENTIFIED BY Password123;
# 修改Host为通配符%
update mysql.user set host % where user root;# 创建用户可以忽略
create user zhangsan% identified by Password123;
# 赋权可以忽略
GRANT ALL PRIVILEGES ON *.* TO zhangsan;# 刷新权限
flush privileges;
# 退出
exit;
# 停止服务
sudo service mysqld stop
my.cnf
# 在etc下新建或修改my.cnf文件如果my.cnf已经存在不要删除也不要修改已经有的配置添加自己的配置在下面即可。
vim /etc/my.cnf
[client]
port3308[mysql]
no-beep[mysqld]
port3308datadir/var/lib/mysql
socket/var/lib/mysql/mysql.socklog-error/var/log/mysqld.log
pid-file/var/run/mysqld/mysqld.pid
skip_ssl
server-id1
character-set-serverutf8mb4
lower_case_table_names1autocommit1
authentication_policymysql_native_password,,
default-storage-engineINNODB
sql-modeONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
long_query_time10
max_connections151
table_open_cache4000
temptable_max_ram1G
tmp_table_size95M
internal_tmp_mem_storage_engineTempTable
myisam_max_sort_file_size2146435072
myisam_sort_buffer_size181M
key_buffer_size8M
read_buffer_size128K
read_rnd_buffer_size256K
innodb_flush_log_at_trx_commit1
innodb_log_buffer_size16M
innodb_buffer_pool_size128M
innodb_redo_log_capacity100M
innodb_thread_concurrency17
innodb_autoextend_increment64
innodb_buffer_pool_instances8
innodb_concurrency_tickets5000
innodb_old_blocks_time1000
innodb_stats_on_metadata0
innodb_file_per_table1
innodb_checksum_algorithm0
flush_time0
join_buffer_size256K
max_allowed_packet64M
max_connect_errors100
open_files_limit8161
sort_buffer_size256K
binlog_row_event_max_size8K
sync_source_info10000
sync_relay_log10000
sync_relay_log_info10000# 注释掉disable_ssl
# disable_ssl
