How can I add a user to mysql to use this php script?

Question

The instructions said:

/*
This is the authentication code for
the administration section.
To add a user, go into MySQL, and type:

INSERT into admin VALUES(
'',
'username',
'password'
);
*/

I tried to insert these values by going into phpMyAdmin and typing a value for the username and password. It doesn't work when I try to log in. Is there something I am doing wrong?

Answer 1

In phpMyAdmin, select your admin table.

Click on the Insert tab.

Just type in the values you want for username and password

Click Go

Answer 2

Have you already created a user account, if not you need to log into mysql as user root (no password) and then add a user. Remember to also set a password for root, as everyone knows this account exists and can use that to compromise your system. To create a full function do-everything account you can enter mysql from the command line - type mysql -u root and enter. Once in type grant all on *.* to whateverusername identified by whateverpassword with grant option;
This creates a full admin user called whateverusername.

Answer 3

On phpMyAdmin do that in the SQl tab it should just insert the values into the database.
If not use the command line!
You should change username to what username you want
and password to the password you want!

Answer 4

Use phpMyAdmin and go to your database. Click the SQL tab and enter the following (replace username by the name you want and password by the password you want):

INSERT into admin VALUES(
'',
'username',
'password'
);


EDIT: Tracy L beat me to it :)