[Setting new MySQL root password on MAMP]

Hello Larry,

 

Thank you for these explanations.
Bit by bit I start understanding how it works.
Regarding the database upgrade, I had upgraded it before changing the password and it works like that anyway. So I just disregard the error message.

 

Best regards,

Julien

[Setting new MySQL root password on MAMP]

Just one more:

Now when I open MAMP, it asks me to upgrade MySQL Databases. And when I try to do so, I get the following message:
mysql_upgrade: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) while connecting to the MySQL server
Upgrade process encountered error and will not continue.
 

[Setting new MySQL root password on MAMP]

Hello Larry, 

Thank you for your swift support.
It was indeed all explained in your book. I was simply not taking it in the correct order. My bad.

After changing the password, my Terminal showed this message:
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
How can I check if my Internet provider gives me a SSL connection?

Now, this shows that actually I don't understand what is MAMP (or XAMPP). So I'm going to ask a series of questions that will probably look stupid to you (sorry about that):
What happens for example, when I place files in the htdocs folder?
Does it "stay" on my computer or is it "sent" over the Internet? I don't understand what is the risk?

When I am going to create a web site, am I going to create and manage my database directly on the space provided by a web-hosting provider through phpMyAdmin or will I do this first on MAMP and then upload it on the server?

 

 

[Setting new MySQL root password on MAMP]

Hello Larry & nomadsoulkarma,

Thank you for your help. i changed the password and the config.inc.php file and I can still access phpMyAdmin from MAMP. So I guess it's alright.

[Setting new MySQL root password on MAMP]

Dear Larry,

I installed MAMP (version 5.01) on my Mac and I tried changing the password of the MySQL root user following the instruction on the MAMP web site, i.e. passing the following command in terminal:
/Applications/MAMP/Library/bin/mysqladmin -u root -p password 

Then I am asked to enter a password. But when I do so I get:

connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

I tried doing it again and entering 'YES' as a password (we never know, it might work), but I get the same result.

Now,  is it really necessary to change the root user password if I am going to use MAMP only to learn and what am I doing wrong?

Thanks in advance for your help.