Bob, Wednesday, February 20, 2002, 2:01:12 AM, you wrote:
BR> I seem to have forgotten how to get into MySQL and work. BR> (It's been a while but I'm starting up again. I get these BR> errors: bob@sfpetard:~> mysqladmin create library BR> mysqladmin: CREATE DATABASE failed; error: 'Access denied BR> for user: '@localhost' to database 'library'' BR> and: bob@sfpetard:~> mysql BR> Welcome to the MySQL monitor. Commands end with ; or \g. BR> Your MySQL connection id is 13 to server version: BR> 3.23.44-Max-log BR> Type 'help;' or '\h' for help. Type '\c' to clear the BR> buffer. BR> mysql> show databases BR> -> ; BR> +-----------+ BR> | Database | BR> +-----------+ BR> | addresses | BR> | inventory | BR> | libes | BR> | mysql | BR> | sample | BR> | test | BR> +-----------+ BR> 6 rows in set (0.01 sec) BR> mysql> use libes BR> ERROR 1044: Access denied for user: '@localhost' to BR> database 'libes' BR> I am doing this on SuSE 7.3. I know there is a user mysql BR> already set up but I don't knwo the password. You should set a permission for the user. The recomended way is to use GRANT statement. Look at: http://www.mysql.com/doc/G/R/GRANT.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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