PDA

View Full Version : Access Denied


azlatin2000
02-24-2004, 02:05 PM
I keep getting this error when i try to connect to my database:
Warning: mysql_connect(): Access denied for user: 'username@localhost' (Using password: YES) in d:\website\DataBaseSetup.php on line 2

MikeParent
02-24-2004, 06:24 PM
Welcome to the hellish world that is remote mySQL administration.
Do you have any way to look at the system tables? You will need to add a records to the db and user tables to give yourself access.

mysql> GRANT ALL PRIVILEGES ON *.* TO username@"%"
IDENTIFIED BY 'password' WITH GRANT OPTION;

azlatin2000
02-24-2004, 07:46 PM
I'm making a site 4 someone else and he is not on aim any more i will tell him tomorow.

Also is there anyway to add colums to a table after using the CREATE TABLE TBLNAME(asd number(5));

Like if i have a table with the colums "a" and "b" can i later add a colmumn called "c"?