系统默认的mysql,好像改过密码,然后,忘了...找回...
#/etc/init.d/mysqlstop
ShuttingdownserviceMySQLdone
#mysqld_safe--user=mysql--skip-grant-tables--skip-networking&
[1]8123
linux-qnfx:/home/liushang#11091104:29:42mysqld_safeLoggingto'/var/log/mysql/mysqld.log'.
11091104:29:42mysqld_safeStartingmysqlddaemonwithdatabasesfrom/var/lib/mysql
按上面这种方法mysqld_safe这个进程直接就死这了,怎么等都没反应。
然后
#/etc/init.d/mysqlstart
StartingserviceMySQLdone
#mysql-umysql
mandsendwith;org.
YourMySQLconnectionidis1
Serverversion:5.1.53-logSUSEMySQLRPM
Copyright(c)2000,,Oracleand/oritsaffiliates.Allrightsreserved.
ThissoftwarecomeswithABSOLUTELYNOWARRANTY.Thisisfreesoftware,
andyouarewelcometomodifyandredistributeitundertheGPLv2license
Type'help;'or'h'forhelp.Type'c'toclearthecurrentinputstatement.
mysql>
再看看下边:
mysql>showdatabases;
+--------------------+
|Database|
+--------------------+
|information_schema|
|test|
+--------------------+
2rowsinset(0.00sec)
mysql>usemysql;
ERROR1044(42000):Accessdeniedforuser''@'localhost'todatabase'mysql'
mysql>
居然没有mysql数据库?那怎么updateuser表呢?
惆怅了...
|
直接重装就没事了,毕竟你没有多少数据库
|
root忘了,学习下怎么找回
|
如果给你找回了,mysql也没人敢用了