Muriel,
Friday, April 26, 2002, 1:14:02 AM, you wrote:
M> My ISP installed MYSQL -max-3.23.49a-pclinux-gnu-i686 on our
M> dedicated server. They discovered they did not install their client
M> libraries after I had already created users with the Grant permissions.
How did you create users?
M> Now that they have reinstalled I can not access mysqladmin in the shell.
M> I cannot even do a shutdown. No one not even root can shutdown the MYSQL
M> server. I did the test in the manual to see if the server can connect:
M> Shell> mysql-u root test It comes back with the server unable to
M> connect.
"Unable to connect" is a too short error message. What is the full
message?
M> In the user table there are three users with all permissions
M> (one of them is root) none of the three users are able to do a shutdown
M> or any of the permissions that are in the table. It comes back with
M> access denied and password = No
It means that you didn't used password when you tried to connect.
So, if you want to connect to the MySQL server you should use:
mysql -u<user_name> -p<password>
or for mysqladmin:
mysqladmin -u<user_name> -p<password> command
You can find description of syntax at:
http://www.mysql.com/doc/m/y/mysql.html
http://www.mysql.com/doc/m/y/mysqladmin.html
M> but it is Y in the user table. What
M> needs to be done? I can with all three users leave the shell and it will
M> accept the passwords and I can go into mysql> and do SQL queries fine.
M> Warm
M> regards,
M> Muriel
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
