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

Reply via email to