to give a particular user access to the database,
log in as root and type
grant all on databasename.* to username identified by "password"
to restrict that user to connecting from a particular host
grant all on databasename.* to username@hostname identified by "password"
the two options above give all permissions to the user (ie read,write,drop
tables,create tables),
to find out more about the GRANT commands syntax take a look at the online
manual on www.mysql.com.
hope that helps
Sean
-----Original Message-----
From: Himadri Mandal [mailto:[EMAIL PROTECTED]]
Sent: 23 August 2001 01:35
To: [EMAIL PROTECTED]
Subject: probs in accessing the database
Dear Friend,
We are a group of students experimenting with MySql.
We have installed MySql version 3.2 under Red Hat
Linux 6.0
We can login to MySql from all the users of Linux
server, However, no users has access to the database
created by root except the root itself.
the text of the error is :
Access denied for user '@localhost' for database
'Daiz'
for information---Diaz is the name of the database
created by root.
help is appreciated.
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.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
---------------------------------------------------------------------
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
