problem with username and password in sql

[Dr Zauis]

Originally Posted by tallerin

those errors are not from a failed login and password. looking through them i would say you are not useing Velious RC1 database.



This is one error i see when people say that they followed the tut and it don't work. You will not get this error useing Velious RC1 Database.If you compiled the latest source release you will have to source in a few lines to fix RC1 and they are posted on PEQ sight.

EDIT:


he can only put it in that way if he name his database eqdr2. Also i have never had an issue useing *.* in that string for any of the DB's i haved used.
so i will still say he is using the wrong DB for 6.2 or something went screwy louy with his Database.

Yep..You are right on the Datbase thing.I didnt notice the items errors I jumped into the grant thing cause I did this the other day and was writing it(Im just using test as name of Database)
*test* then I went to sesmars tut and he wrote it test.* Now I see I could have also wrote *test.* and that should work to..Thanks.

[jimm0thy]

The *.* will grant root privilages to all databases , instead of identifying one.

Also please remember that when it says to input

GRANT ALL PRIVILEGES ON *.* TO Username@localhost IDENTIFIED BY 'Password' WITH GRANT OPTION;

That you have to replace Username with your username , and password with your password. So basically it would look like ..

GRANT ALL PRIVILEGES ON *.* TO Bob@localhost IDENTIFIED BY 'Smith123' WITH GRANT OPTION;

[dasgood]

I use my username and password and hit enter. The response is:

Query OK, 0 rows affected (0.00 sec)

Doesn't that mean it didn't do anything?

[Belfedia]

Thats good, don't forget to put your name and password in db.ini