RE: [cobalt-users] mysql on raq4

["scott" <scott@xxxxxxxxxxxxxxxxxxxxxx>]

-----Original Message-----
From: cobalt-users-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-users-admin@xxxxxxxxxxxxxxx] On Behalf Of Kameel
Sent: 23 August 2002 12:53
To: cobalt-users@xxxxxxxxxxxxxxx
Subject: Re: [cobalt-users] mysql on raq4


Heya Scott,

You have to change user to the root, and then create the database or
grant 
permission to do so to additional users.
To change to the root type:
su -
Then enter the admin password.

Hope this helps,
Kam.

p.s. - Don't forget to assign permission for your user to actually use
the 
database, or they will get an access denied message when trying to do 
anything with it !


Can't seem to actually get in to change anything.
Scott
Look below
[root admin]# su -
*****************************************************************
*                                                               *
* NOTICE TO ROOT USER: Changes to system files may affect       *
* your warranty. Please consult your warranty card for details. *
*                                                               *
* http://www.cobalt.com                                         *
*                                                               *
*****************************************************************
[root /root]# mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password:
NO)
[root /root]# mysql -u root -p
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password:
YES
[root /root]# mysql -u root
ERROR 1045: Access denied for user: 'root@localhost' (Using password:
NO)
[root /root]# mysql -u admin
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 108 to server version: 3.23.37

Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql> use mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql> exit


>Hello gang
>Bit of a newbie here
>How do I create a new my sql database on my raq4. I telnetted in (as
>admin) and tried to create database blah but got an 'access denied for 
>user @locahost to database blah' Help
>Thanks
>Scott

_____________________________________
cobalt-users mailing list
cobalt-users@xxxxxxxxxxxxxxx
To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
http://list.cobalt.com/mailman/listinfo/cobalt-users