View Full Version : Access Denied
azlatin2000
02-24-2004, 01: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, 05: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, 06: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"?
vBulletin® v3.8.6, Copyright ©2000-2012, Jelsoft Enterprises Ltd.