| View previous topic :: View next topic |
| Author |
Message |
berkay
Tux's lil' helper
Joined: 27 Aug 2004
Posts: 76
|
 Posted: Fri Oct 01, 2004 9:08 pm Post subject: Mysql user cannot create database? |
 |
|
Hi all,
When I start mysql client with user mysql
it successfully goes to command line, then I can see the databases... but when I
| Code: | | create database dbname; |
, it gives the following error...
| Code: | | ERROR 1044: Access denied for user: '@localhost' to database 'dbname' |
How can I fix this error... |
|
| Back to top |
|
 |
spatz
Retired Dev
Joined: 21 Sep 2002
Posts: 61
Location: Israel
|
| Posted: Fri Oct 01, 2004 9:21 pm Post subject: |
|
|
Try to use
to connect and you will have permissions to create a db. |
|
| Back to top |
|
|
berkay
Tux's lil' helper
Joined: 27 Aug 2004
Posts: 76
|
| Posted: Fri Oct 01, 2004 10:00 pm Post subject: |
|
|
Is that root user my system's root user or such a mysql user? If it is mysql user, then there is no problem... What is it?
Thanks... |
|
| Back to top |
|
|
fleed
l33t
Joined: 28 Aug 2002
Posts: 756
Location: London
|
| Posted: Sat Oct 02, 2004 8:30 am Post subject: |
|
|
| mysql only, separate password and all |
|
| Back to top |
|
|
berkay
Tux's lil' helper
Joined: 27 Aug 2004
Posts: 76
|
| Posted: Sat Oct 02, 2004 10:11 am Post subject: |
|
|
Ok then, thanks for help  |
|
| Back to top |
|
|
berkay
Tux's lil' helper
Joined: 27 Aug 2004
Posts: 76
|
| Posted: Sat Oct 02, 2004 10:11 am Post subject: |
|
|
| Ok then, thanks for help |
|
| Back to top |
|
|
|
Networking & Security
