mysql⽆法启动-
刚安装的mysql⽆法启动，提⽰没有权限
The innodb_system data file 'ibdata1' must be writable
无法为jsp编译类怎么解决[root@localhost ~]# mysqld --initialize
[root@localhost ~]# systemctl start mysqld
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
⼀ ⽆法启动mysql，可以查看mysql⽇志 默认路径
/var/log/mysql.log
2020-03-20T02:12:57.667801Z 1 [ERROR] [MY-012271] [InnoDB] The innodb_system data file 'ibdata1' must be writable 2020-03-20T02:12:57.668066Z 1 [ERROR] [MY-012278] [InnoDB] The innodb_system data file 'ibdata1' must be writable 2020-03-20T02:12:57.668410Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2020-03-20T02:12:57.668897Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-03-20T02:12:57.669159Z 0 [ERROR] [MY-010119] [Server] Aborting
0-1.png
mysql⽇志报错
手机百度app下载官方正式版根据⽇志查看提⽰，是innodb⽂件没有写⼊权限
查ibdata1⽂件路径
[root@localhost ~]# find / -name ibdata1
/var/lib/mysql/ibdata1
[root@localhost ~]# chmod -R 777 /var/lib/mysql
微服务
[root@localhost ~]# chown mysql:mysql -R /var/lib/mysql
0-2.png
三 接着启动服务
[root@localhost ~]# systemctl start mysqld.service
[root@localhost ~]# systemctl status mysqld.service
0-3.png
其他注意事项
td会继承table中的边框颜吗
另外注意⼀下mysql初始化的密码 也记录到 mysqld⽇志⾥⾯
[root@localhost ~]# cat /var/log/mysqld.log
低价网站建设2020-03-20T02:12:15.251589Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.19) initializing of server in progress as process 335
mysql无法连接到服务器2020-03-20T02:12:19.068387Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: fyIGo9o9(t.p
2020-03-20T02:12:57.636850Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.19) starting as process 492
[root@host]# mysqladmin -u root password "new_password";
然后可以通过以下命令来连接到Mysql服务器：
[root@host]# mysql -u root -p Enter password:*******
出现问题的时候，要多查看⽇志。根据⽇志信息能锁定问题

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。