Dear Mike,
first check if you have the mysql database installed. This holds the
tables of the so called privilege system which handles the access
rights.
Then, log in *somehow* to the MySQL server (usually, for the first time,
with Unix root account and *no* password), and enter
GRANT ALL ON *.* TO superuser@localhost IDENTIFIED BY "secret" WITH
GRANT OPTION
Log off off the database server. Try to connect again as "superuser".
This should work, regardless which Unix user you are (root or "regular"
user).
Now, you (superuser) can grant rights to "regular" MySQL users. Check
the MySQL manual for GRANT.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: "root" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 23, 2001 5:43 PM
Subject: Cannot set root password
> I have tried everything that I know to set the root password but I
keep
> getting denied. I finally got the daemon running so now I need to set
the
> root password. I have not yet set a pw so I can not understand why I
am
> getting denied. I looked at the manual online and it gave the
following
> suggestions:
> If you get an error like the following:
> shell> mysqladmin -u root -pxxxx ver
> Access denied for user: 'root@localhost' (Using password: YES)
>
> It means that you are using a wrong password. See section 6.15 Setting
Up
> Passwords. If you have forgot the root password, you can restart
mysqld
> with --skip-grant-tables to change the password. You can find more
about
> this option later on in this manual section. If you get the above
error
> even if you haven't specified a password, this means that you a wrong
> password in some my.ini file. See section 4.16.5 Option Files. You can
> avoid using option files with the --no-defaults option, as follows:
> shell> mysqladmin --no-defaults -u root ver
>
> This is the exact error I am getting and I have searched for my.cnf,
> my.conf, ~/.my.cnf , and $DATADIR/my.cnf file to no avail. I have
tried
> putting --no-defaults with the password reset statement as shown
below:
>
> /mysqladmin --no-defaults -u root -p password new-password
>
> One question I have about that statement though, How can I put a
password
> if there is not one. Anyway, any help provided would be greatly
> appreciated. Thanks in advance.
>
> Mike
>
> Matthew 4:18-20
> (18) And walking by the Sea of Galilee, Jesus saw two brothers, Simon
> called Peter, and Andrew his brother, casting a net into the sea. For
they
> were fishermen.
> (19) And He said to them, Follow Me, and I will make you fishers of
men.
> (20) And they immediately left their nets and followed him.
>
>
> ---------------------------------------------------------------------
> 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
