Basically, my goal has been to set up a local instance of php, mysql and phpMyAdmin so that I could test my php pages and the db content locally before I copied them up to the live server.
I've been working on this for days. My ISP does not allow remote connection to the db (hence my attempt to do it locally)
I installed mysql, phpmyadmin and made sure my Apache and php were working. I am now attempting to get into the phpMyAdmin scrren in order to built my table. I am very very new to all of this.
Currently, I cannot connect with the mysql db via phpMyAdmin. I get this error:
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
I tried adding a password into the config.inc.php file (didn't help)
I tried adding a password to mysql and all I get are errors (I'm really not sure I'm doing it correctly though) I've been in Terminal and then I downloaded a program: "My Query Browser". Tried to run
SET PASSWORD FOR 'root' = PASSWORD('new_pass');
this did nothing but give me an error
So I read somewhere to try this:
/usr/local/mysql/bin/mysqladmin -u root password buttonbling
(I want my new password to be buttonbling)
And I got this error:
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Whats the most basic way for me to check that I have mysql running correctly on my G4? Why might I not be able to connect to the mysql via the phpMyAdmin?
How far back do I need to take this - shall I uninstall everything and start from scratch?
I did install that little app that will reboot mysql if I were to shut my computer off and restart.
Thank you for any help you may be able to provide
I've been working on this for days. My ISP does not allow remote connection to the db (hence my attempt to do it locally)
I installed mysql, phpmyadmin and made sure my Apache and php were working. I am now attempting to get into the phpMyAdmin scrren in order to built my table. I am very very new to all of this.
Currently, I cannot connect with the mysql db via phpMyAdmin. I get this error:
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
I tried adding a password into the config.inc.php file (didn't help)
I tried adding a password to mysql and all I get are errors (I'm really not sure I'm doing it correctly though) I've been in Terminal and then I downloaded a program: "My Query Browser". Tried to run
SET PASSWORD FOR 'root' = PASSWORD('new_pass');
this did nothing but give me an error
So I read somewhere to try this:
/usr/local/mysql/bin/mysqladmin -u root password buttonbling
(I want my new password to be buttonbling)
And I got this error:
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Whats the most basic way for me to check that I have mysql running correctly on my G4? Why might I not be able to connect to the mysql via the phpMyAdmin?
How far back do I need to take this - shall I uninstall everything and start from scratch?
I did install that little app that will reboot mysql if I were to shut my computer off and restart.
Thank you for any help you may be able to provide
