Adding users

Whenever I try to add a user in MySQL it always says access denied even tho I use the user/pass combo I created it with. Any ideas?

Are you using the standard GRANT syntax?

GRANT SELECT ON dbname.* TO username IDENTIFIED BY 'password'; ?

If you are just doing straight insertion into the mysql.user table, you need to PASSWORD(password) the password in order for it to be properly encrpyted.

I did a strait insert on the mysql user table and I did encrypt the password(password('pass'))

You need to do "FLUSH PRIVILEGES" to make MySQL re-read the tables. If you use GRANT, you don't have to do it...

I do flush privileges but it doesn't work.

You did also add some privileges, right (insert_priv, select_priv, etc.)?

Anyway, what is the exact SQL command you're using?

I don't know if I added privileges but it wouldn't even let me connect, let alone do commands.

Well, how did you add a user then?

I think I just added it directly the user table in the mysql database. I did it w/ all privileges.
Warning: mysql_connect(): Access denied for user: 'sliver@localhost' (Using password: YES) in c:mitchwebmysqlmanconfig.php on line 4
mysql failure: Access denied for user: 'sliver@localhost' (Using password: YES). I did use password('pass') when I inserted.

If you have control of MySQL server, you can start it with --skip-grant-tables.. it will disable the authentication mechanism, so you can edit your details. Don't forget to restart it later, otherwise anyone can connect to it...
If you don't have control, you'll have to ask someone that does to fix your privilege data ...

Yeah I do have control. I'll try that and I guess I can just stick w/ root.