Phil,
Monday, May 06, 2002, 1:42:28 PM, you wrote:
PD> I've just installed MySQL 3.23.49 on Mac OS X.1.4. The installation went fine
(into /usr/local/) but now I'm having what I believe is a common permission problem.
When trying to add a database I
PD> get the following error:
PD> [localhost:~] phil% mysql
PD> Welcome to the MySQL monitor. Commands end with ; or \g.
PD> Your MySQL connection id is 12 to server version: 3.23.49-entropy.ch
PD> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
PD> mysql> create database CONTACT;
PD> ERROR 1044: Access denied for user: '@localhost' to database 'CONTACT'
PD> I couldn't find anything in the archives so I wondered, could somebody let me know
the workaround I need to do on the permissions to get me started?
By default anonymous user ('') has permissions only on the database
'test'. You should have permissions to create databases. You can find
a lot of info about MySQL privilege system in our manual:
http://www.mysql.com/doc/P/r/Privilege_system.html
http://www.mysql.com/doc/U/s/User_Account_Management.html
PD> Any help appreciated.
PD> Regards,
PD> Phil.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
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
