MySQL使用者刪不掉 - Linux
By Edward Lewis
at 2010-04-06T20:33
at 2010-04-06T20:33
Table of Contents
我系統是 CentOS 5.4
MySQL版本5.0.77
我用以下SQL語法在phpmyadmin上執行新增使用者---------------------------
CREATE USER ' Jerry '@'localhost' IDENTIFIED BY ' 12345 ';
GRANT USAGE ON * . * TO ' Jerry '@'localhost' IDENTIFIED BY ' 12345 '
WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0
MAX_USER_CONNECTIONS 0 ;
CREATE DATABASE IF NOT EXISTS ` Jerry ` ;
GRANT ALL PRIVILEGES ON ` Jerry ` . * TO ' Jerry '@'localhost';
-----------------------------------------------------------------------
很明顯的 我帳密裡都有空白 但SQL指令卻執行了.....
現在是使用者都砍不掉 SQL指令也試過了
Database用指令不行要用人工才砍的掉
請問我該怎麼辦??
有辦法整個MySQL重灌嗎 我該怎做?
--
MySQL版本5.0.77
我用以下SQL語法在phpmyadmin上執行新增使用者---------------------------
CREATE USER ' Jerry '@'localhost' IDENTIFIED BY ' 12345 ';
GRANT USAGE ON * . * TO ' Jerry '@'localhost' IDENTIFIED BY ' 12345 '
WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0
MAX_USER_CONNECTIONS 0 ;
CREATE DATABASE IF NOT EXISTS ` Jerry ` ;
GRANT ALL PRIVILEGES ON ` Jerry ` . * TO ' Jerry '@'localhost';
-----------------------------------------------------------------------
很明顯的 我帳密裡都有空白 但SQL指令卻執行了.....
現在是使用者都砍不掉 SQL指令也試過了
Database用指令不行要用人工才砍的掉
請問我該怎麼辦??
有辦法整個MySQL重灌嗎 我該怎做?
--
Tags:
Linux
All Comments
By Bennie
at 2010-04-10T11:49
at 2010-04-10T11:49
By Robert
at 2010-04-13T15:53
at 2010-04-13T15:53
By Rosalind
at 2010-04-17T21:33
at 2010-04-17T21:33
Related Posts
Mandriva安裝檔的問題
By Catherine
at 2010-04-06T16:06
at 2010-04-06T16:06
Songbird宣佈將研發重心轉移到Win和Mac上
By Caroline
at 2010-04-06T13:49
at 2010-04-06T13:49
Mandriva安裝檔的問題
By Hedy
at 2010-04-06T13:41
at 2010-04-06T13:41
Mandriva安裝檔的問題
By Caitlin
at 2010-04-06T13:23
at 2010-04-06T13:23
怎樣子跟X Server 要求特定Window 當中的變化!!!?
By Kelly
at 2010-04-06T00:47
at 2010-04-06T00:47