I've port forwarded 3306 (which I've double checked the MySQL server is running on that port) through my router (and the firewall settings in the router) to the server's LAN IP. Then when I try connecting to via the Internet IP I get this error: MySQL said: Host '192.168.0.1' is not allowed to connect to this MySQL serverĪfter 'Googling' I thought it'd be a GRANT ALL command to resolve the issue, but I ran the following command and still have the problem: GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY 'password' The default username for a new MySQL installation is root, with a blank password. Run this /usr/bin/mysqlupgrade -u root -p This should reset the rights and grant access with u logged in as 'root''localhost' Thereafter run this /usr/bin/mysql -u root -p. However when trying to use Sequel Pro to connect to it gives me this error: MySQL said: Access denied for user (using password: YES). Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases. Moreover, Sequel Pro works with MySQL databases in a native Mac OS X. I have a domain with 1and1, and created a sub domain () and created an A record to point to my internet IP (where the server is) and that all works fine. If you follow the Windows directions and try to access phpMyAdmin by going to localhost/xampp or localhost/phpmyadmin, youll get a screen like this one: The. Sequel Pro is a free and open-source application that allows you to easily wok with database-driven websites and applications. I've installed MySQL on OSX Lion, however I can't connect to the MySQL server via phpMyAdmin (or Sequel Pro).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |