Check the manual for the GRANT command. It holds the secret that you are
searching for. :) You can use it to grant specific rights to databases or
tables within databases.
Once you have granted rights for a user, then use
mysql -u username -p
the -p is only necessary if the user you are trying to login in as needs a
password.
HTH,
Cal
http://www.calevans.com
-----Original Message-----
From: Jerry Davis [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 17, 2001 9:15 AM
To: MYSQL
Subject: Access rights
1) How do I give access to other users in MySQL?
2) How do I give access to tables to other users?
3) How do I create another database and then give access to that database to
other users?
I can get into the test database as user x
but I can't get even get an access error when trying mysql with user root.
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
Jerry
--
Boycott the outlaw Microsoft - and use Linux - the Software that gives you
Freedom to choose!
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
