密码忘了 所以用安全模式进入数据库改了一下密码。
然后就悲剧了。
以前service mysqld start 可以启动 现在启动不了了
只能用安全模式进入了。
输入service mysqld start 显示mysqld未识别。
稍后上图 冰天雪地全裸跪求大神指点。LinuxMySQL启动不了
然后就悲剧了。
以前service mysqld start 可以启动 现在启动不了了
只能用安全模式进入了。
输入service mysqld start 显示mysqld未识别。
稍后上图 冰天雪地全裸跪求大神指点。LinuxMySQL启动不了
package mysql is not installed
cd /etc/init.d/mysqld start 也是启动不了
但是安全模式就可以启动。
Non-mmapped space allocated from system: 581632
Number of free chunks: 16
Number of fastbin blocks: 0
Number of mmapped regions: 2
Space in mmapped regions: 16781312
Maximum total allocated space: 0
Space available in freed fastbin blocks: 0
Total allocated space: 270104
Total free space: 311528
Top-most, releasable space: 126672
Estimated memory (with thread stack): 17362944Events status:
LLA = Last Locked At LUA = Last Unlocked At
WOC = Waiting On Condition DL = Data Locked
The Event Scheduler is disabled130418 09:29:54 mysqld_safe A mysqld process already exists
130418 09:30:24 mysqld_safe A mysqld process already exists
130418 09:30:51 mysqld_safe A mysqld process already exists
130418 9:44:36 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown130418 9:44:36 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete130418 09:44:36 mysqld_safe mysqld from pid file /usr/local/mysql/var/232.kela.cn.pid ended
在etc/init.d/mysqld start 显示 -bash: mysqld: command not found
但是如果用 /usr/local/mysql/bin mysqld_safe -skip-grant-tables 就可以启动。
ll一下 发现mysqld没有权限
chmod +x mysqld
cd ../..
service mysqld start成功启动。但是启动还是用安全模式启动的...
怎么退出安全模式呢?
killall -TERM mysqld service mysqld start
进入安全模式想修改权限
use user 提示
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'user'
cd /usr/local/mysql/bin
mysql -uroot -p123456
显示 Access denied for user 'root'@'localhost' (using password: YES)