CODEWITHSUNDEEP
mysqlosx-elcapitan
Filippos
Filippos

Reputation: 11

Cannot connect to mysql server in El Capitan

I want to learn joomla and so far i've followed the instructions online on how to enable the apache and php on my El Capitan mac but im having issues with MySQL. I downloaded the dmg file and installed MySQL and also installed the phpmyadmin files. Started the apache and mysql server.

phpmyadmin webpage loads, instructions are followed carefully but for some reason i can not login into the phpmyadmin with the root and temp password from the installation. Also used the shell with many commands ( ex. mysql -v root -p ) but the temporary password never gets accepted.

Tried changing the password (from online help), nothing worked.

Tried every possible solution online but it seems php (from phpmyadmin or joomla installation) can not communicate with mysql or password never gets accepted. No idea.

Any help?

Upvotes: 1

Views: 495

Answers (1)

Redbeard011010
Redbeard011010

Reputation: 964

Try using this link to reset the root password: http://veerasundar.com/blog/2009/01/how-to-change-the-root-password-for-mysql-in-xampp/

And then try this login string mysql -uroot -p

It will prompt you for your password. If this fails, try specifying the port and host. ie mysql -uroot -p -P3306 -h127.0.0.1

Another method to set the root password, according to Google (I've never done it this way):

How can I set a root password in MySQL? Configure it with the "XAMPP Shell" (command prompt). Open the shell from the XAMPP control pane and execute this command: mysqladmin.exe -u root password secret This sets the root password to 'secret'.

Upvotes: 1

Related Questions