Mysql51-server安裝問題...無基本sql資料庫? - BBS
By Isabella
at 2007-01-24T11:01
at 2007-01-24T11:01
Table of Contents
請問一下....如何設定mysql root 密碼呢?
http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html
我已經按照上面的指令
shell> mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');
ERROR 1133 (42000): Can't find any matching row in the user table
輸入,可是我輸入完畢他會說error..
該怎麼辦呢...
另外我看show databases他只有顯示以下兩個..
mysql> show databases
-> ;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.01 sec)
帳號密碼應該是要在sql資料庫裡面吧我這邊怎麼沒有呢...Orz...
我的freebsd 6.1prerelease
我的mysql51是最新FreeBSD Port安裝的:mysql-server-5.1.14
我之前因為安裝kde,作業要求要灌mysql51-server......
所以把比較舊的mysql版本client以及server用 make deinstall取消安裝
再用ports安裝了最新的版本(我有portupgrade...)
除此之外MYSQL本身我都沒有動過...開啟來救只有那兩個資料庫....
請各位幫我想想辦法..Orz....
thanks!!!
--
--
http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html
我已經按照上面的指令
shell> mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');
ERROR 1133 (42000): Can't find any matching row in the user table
輸入,可是我輸入完畢他會說error..
該怎麼辦呢...
另外我看show databases他只有顯示以下兩個..
mysql> show databases
-> ;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.01 sec)
帳號密碼應該是要在sql資料庫裡面吧我這邊怎麼沒有呢...Orz...
我的freebsd 6.1prerelease
我的mysql51是最新FreeBSD Port安裝的:mysql-server-5.1.14
我之前因為安裝kde,作業要求要灌mysql51-server......
所以把比較舊的mysql版本client以及server用 make deinstall取消安裝
再用ports安裝了最新的版本(我有portupgrade...)
除此之外MYSQL本身我都沒有動過...開啟來救只有那兩個資料庫....
請各位幫我想想辦法..Orz....
thanks!!!
--
--
Tags:
BBS
All Comments
Related Posts
Re: about samba
By Victoria
at 2007-01-24T02:24
at 2007-01-24T02:24
apache設定openssl的問題
By Carolina Franco
at 2007-01-24T02:21
at 2007-01-24T02:21
apache設定openssl的問題
By Isla
at 2007-01-24T00:01
at 2007-01-24T00:01
驅動usb無線網卡
By Rae
at 2007-01-23T23:55
at 2007-01-23T23:55
KDE問題
By Vanessa
at 2007-01-23T18:19
at 2007-01-23T18:19