LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   mysql-administrator error could not retrive user information (https://www.linuxquestions.org/questions/linux-software-2/mysql-administrator-error-could-not-retrive-user-information-467205/)

narutovsvegito 07-24-2006 03:04 PM

mysql-administrator error could not retrive user information
 
i installed mysql, logged as root i ran the mysql_install_db, followed the instruction on changing the password for root and the host.

when i log in as non-root i type mysql and i dont get challanged. if im logged in as root, and i type mysql i get an error, so i have to log in with mysql -u root -p<enter> then i get challanged for my password.

it doesnt matter if im root or non-root when i run mysql-administrator, and i try to access "user administration" i get an error, could nor retrive user information. logged in as root mysq is protected and logged in as non-root mysql is open.

if i try to enter a password for mysql while non-root i get an error, access denied '' @ localhost (password : NO).

i can login to mysql-administrator using sa /w no pw, mysql with no pw and non-rootuser@localhost with no pw, all while pointing to 127.0.0.1 or pcname.site, either way i get the same results


All times are GMT -5. The time now is 02:19 AM.