Kamal Ahmed wrote:
Hi,
This is the only place where I can ask these questions, and would greatly appreciate if anyone can give me some clue on how to resolve these issues.
I have MySql running on Redhat 9, and I am trying to create a New Database.
When I issue the command: mysqladmin -u root ver
Result: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
Command: [EMAIL PROTECTED] home]# mysqladmin -u root flush-privileges password "abcdef"
Result: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
Q1. How can I change the password for root ? Q2. How do I know if root IS the admin for MySql ? Q3. How can I add a Database ? Q4. How can I add a New User to a New Database ?
If you have installed the database yourself, you should know the password, _or_ RH set a default password, in which case you should try the redhat list.
Try using the password that you actually use for root. (we never know...) And try both :
mysql -u root -h localhost
mysql -u root
but, there is nothing else we can do to help.
-- Philippe Poelvoorde COS Trading Ltd.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
