mySQL 1044 error message
Hi,
I just installed mySQL, which I'm just starting to learn. When I tried to create a database and I got a '1044 error message', user access denied. How can I gain access?
Thanks,
TonyMontana
akaMethodAir
http://www.electricmountain.com
mairving posted this at 19:51 — 27th February 2002.
They have: 2,256 posts
Joined: Feb 2001
Are you connecting from the command line or via a script?
Mark Hensler posted this at 21:08 — 27th February 2002.
He has: 4,048 posts
Joined: Aug 2000
At the command line, login with:
mysql -u username -p
For help at the command line, use:
mysql --help
TonyMontana posted this at 02:51 — 28th February 2002.
They have: 218 posts
Joined: Apr 2001
'Are you connecting from the command line or via a script?'
From the command line, after the login.
TonyMontana
http://www.electricmountain.com/home.htm
mairving posted this at 04:17 — 28th February 2002.
They have: 2,256 posts
Joined: Feb 2001
To connect as the root user for MySQL if no password:
mysql -u root
to connect as another user
mysql -u username -ppassword
You can also specify a host
mysql -h hostname -u username -ppassword
You generally don't have to specify the host since the default will be localhost.
Note that there is a space after the u and username but not after p and password.
Mark Irving
I have a mind like a steel trap; it is rusty and illegal in 47 states
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.