MySql On Sierra 10.12.3

Question

chrisfromyarm OP

Created Mar ’17

Replies 2

Boosts 0

Participants 3

Hi All,

I am having issues trying to install and operate MySql V.5.7.17 on Sierra 10.12.3.

I can run and stop MySql but the tempory password provided during the install does not allow me to login via phpMyAdmin.

The files display correctly in my browser at localhost/~myusername and http://localhost does display 'It Works'.

The phpMyAdmin login page launches when I navigate to the folder http://localhost/~myusername/phpmyadmin.

I am using the user name: root

& The password provided during the mySql install process.

The error is 'password expired' or I have also had 'Root Access denied using password YES'. I have made a number of fresh installs now so that's why the different errors I think. I also ended up with http://localhost giving an error along the lines of 'Access denied you are not allowed to access this server.' However, I was still able to access http://localhost/~myusername/phpmyadmin.

Using terminal and having stopped mySql running the command 'sudo mysqld_safe --skip-grant-tables' does appear launch mySql in safe mode.

Using a new Terminal window no other commands work. So I cannot reset the root password using the following method:-

mysql -u root

FLUSH PRIVILEGES;

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

\q

Anyone have any experience of this issue?

I have now reinstalled os 10.12.3 which sorted out the access to localhost but was hoping to get some feedback before attempting to install MySql V.5.7.17 again.

My objective is to run and develop a simple php/mySql website that I have purchased as a file set. The site runs fine on an external server, but I am not able to easilly develop in that environment. The site is built on a Bootstrap framework. I am wanting to use the Pinegrow App for development but this requires the website running locally.

If there are any other methods to edit and develop this kind of website I am open to suggestions.

Thanks in advance.

Boost

Answer 1

john daniel OP

Mar ’17

Hello chrisfromyarm,

I haven't used MySQL in a long time. It sounds like you just don't have the server properly configured. A few years ago I wrote up a User Tip on Apple Support Communities for setting up such a local webserver: https://discussions.apple.com/docs/DOC-3082

That tutorial may be out of date. If you can't get it to work, you might have to ask for help somewhere like Stack Overflow. Local MySQL servers aren't something that people tend to do anymore. There are lots of other options these days. You can run MySQL on Azure, Heroku, AWS, etc. You can run it locally using Docker too, although you might have the same setup issues and debugging that in Docker would be a royal pain.

0

Answer 2

KMT OP

Mar ’17

Since you are not using a beta macOS, Install/Setup/Configuration questions might have better luck over on Apple's public support forums, thanks and good luck.

https://support.apple.com/macos

0