Re: User and Privilege managment
Quote
Please:
1 Check that MySQL is running on address 127.0.0.1
2 Check that MySQL is reachable on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the user root has rights to connect to 127.0.0.1 from your address (MySQL rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from
For #1, try ...
cd /Applications/Ampps/mysql/bin
$ mysql.server restart
... or ...
alias mysqlstart='sudo /usr/local/mysql/support-files/mysql.server start'
alias mysqlstop='sudo /usr/local/mysql/support-files/mysql.server stop'
What results did checks 2-4 yield?
Did you find or create my.cnf?
Have you tried starting the server with --skip-grant-tables ?
Subject
Views
Written By
Posted
757
July 10, 2022 12:17PM
390
July 10, 2022 09:15PM
375
August 01, 2022 07:39AM
425
August 01, 2022 08:51AM
384
August 05, 2022 08:07AM
519
August 06, 2022 10:37AM
Re: User and Privilege managment
368
August 06, 2022 07:39PM
417
August 07, 2022 12:02PM
502
August 07, 2022 12:37PM
406
July 31, 2022 12:13PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.