I didn't had a "mysql" directory, though it must be there in order to work.įourth, I copied the "mysql" directory from a different machine to C:\wamp64\bin\mysql\mysql5.7.19\data, and restarted All Services through WAMP. I noticed that some directories where missing. The location of that directory on my machine was: C:\wamp64\bin\mysql\mysql5.7.19\data. Third, after interpreting the errror log I navigated to the mysql data directory. T14:54:37.216151Z 0 Fatal error: Can't open and lock privilege tables: Table 'er' doesn't exist Dealing with MAMP Failing to Start and Stop MySQL on Windows Webucator 6. T14:54:37.215551Z 0 Failed to open optimizer cost constant tables Table 'mysql.gtid_executed' cannot be opened. T14:54:37.211344Z 0 Gtid table is not ready to be used. and start wamp windows will ask is msqlnt.exe allowed to run and accept it then its fine. T14:54:37.207560Z 0 Can't open the ugin table. You need to allow the service mysql on windows firewall/ after you install wamp, restart ur pc. Second, I saw errors like this: wampmysqld64: Table 'ugin' doesn't exist Read below how I solved it in my situation.įirst, I checked the MySQL Log. I had the exact same problem but my situation was different (I use WAMP 3.1 i.c.w. You must then use HTTP-tunneling or SSH-tunneling to connect. Then carefully configure the MAMP version. Delete the version refs that you do not want from the hard disk, registry, env variables. When trying to connect to a MySQL server at an ISP this error message often indicates that direct connection to MySQL has been blocked. WAMP MAMP
0 Comments
Leave a Reply. |