jan gestre wrote:
jan gestre wrote:the program itself is not portable, i won't be asking for help if it is, right :D sakit na ulo ko d2 eh, hirap ng nde programmer.
Yeah, I know how it feels when you got a site that's not working as it supposed too.
when i edited config.php, i forgot to put a semicolon on this line, my bad.

$db_pass                        =       "newpassword"; <----- this line
// $db_pass                        =       "origpassword";
everybody make mistakes. (`c`,)

so when i try to run it again, i got a new error:

Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES) in /var/www/pjn/pjn/include/patDbc.php on line 254
Couldn't connect to database
Host: localhost
Database: pjndb
User: root
MySQL said: Access denied for user 'root'@'localhost' (using password: YES)

i tried to use the old password with the same result, below is the line 254 mentioned in the error.
you may need to change your root password in mysql from the default (usually none) to whatever you want to use.  Or better yet, create a new (non-root) mysql user with permission to use that database, like:

GRANT ALL PRIVILEGES ON pjndb.* TO [EMAIL PROTECTED] IDENTIFIED BY 'newpassword';
FLUSH PRIVILEGES;

you'd type the above in mysql cli (mysql -u root -p)

if you want to change the root password do something like:
USE mysql;
UPDATE user SET Password=PASSWORD("<newpassword>") WHERE User="root";



__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

_________________________________________________
Philippine Linux Users' Group (PLUG) Mailing List
[email protected] (#PLUG @ irc.free.net.ph)
Read the Guidelines: http://linux.org.ph/lists
Searchable Archives: http://archives.free.net.ph

Reply via email to