MYSLQ not working
Posted by: krew (47.147.191.---)
Date: January 26, 2017 04:05AM

Hey Guys,

I cannot get mySQL working correctly, This is fresh install with the latest versions.
I had to change the port of Apache to 8080.

Apache is working fine and i can get on the localhost page with all the settings.

Once i try to login to PHPmyadmin I get a #2002 Error.

Here are the logs from mySQL

wampmysqld64: Table 'mysql.plugin' doesn't exist
2017-01-26T02:53:53.339854Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-01-26T02:53:53.339854Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-01-26T02:53:53.339854Z 0 [Warning] Failed to open optimizer cost constant tables

2017-01-26T02:53:53.339854Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2017-01-26T02:53:53.339854Z 0 [ERROR] Aborting



any help

Options: ReplyQuote
Re: MYSLQ not working
Posted by: krew (47.147.191.---)
Date: January 26, 2017 05:06AM

Nevermind I Fixed It.

The Installation Said wait 30 seconds... to finish and i waited about 5 minutes and nothing happened so i ended the task.. well that screwed everything up..

I reinstalled and waited for it to finish completely.

Works now.

Options: ReplyQuote
Re: MYSLQ not working
Posted by: Otomatic (Moderator)
Date: January 26, 2017 04:22PM

Hi,

Quote
krew
The Installation Said wait 30 seconds... to finish and i waited about 5 minutes and nothing happened so i ended the task.. well that screwed everything up..
This is the time taken by MySQL to create the entire data folder, that is to say the databases mysql, performance_schema, sys and others files for a total of about 35 MB and 275 files.

With a SSD drive it takes about four seconds and about thirty seconds with a standard SATA 3 HDD.

If it takes you more than five minutes, there is a big problem with your system.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Options: ReplyQuote


Sorry, only registered users may post in this forum.