Error: 1064

Anon

I am trying to set up a username, host, and password for my mysql table. The problem I am encountering is that when I type the following under the mysql command line whlie using the table mysql:

insert into user (host, user, password) values ('localhost', 'usernamehere', password('passwordhere');

and hit Enter, I get error 1064 (I don't know what that means) and it says that it is on line 1.

I am SOOOO new to this, so please help me out. What did I do wrong?

Anon

hello ,
Here u need to close the closing bracket properly
just do it like this,

insert into user (host, user, password) values ('localhost', 'usernamehere',
password('passwordhere') );

Error 1064 occurs here becuase of syntax problem u have.

it works without any problem.

Anon

Okay, I got the user name and password in the database, but I have one that I don't want in there, in there. What should I do?

Also, when I execute this script (when its php of course) it says that it can't connect to the database when the username and password are correct...

However, when I leave the username and password blank and have the host set to localhost, the php page is able to connect with "success". Please help! 🙂

script:
http://gamecubetogo.com/gbasite/db_connect.txt