Code Bug Fix: I have installed mySQL WAMP recently and by that time I already installed mySQL

Original Source Link

I can’t find a way to connect my phpmyadmin to the mySQL Server, t keeps giving me the error, “:mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]” and “mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client”. I hadn’t chosen the option where you can install the mySQL but there was an unchangeable setting that installs mariaDB. So I installed mariaDB but not the mySQL, could that that be one of the factors of the problem?

I have been using this mySQL for a whole month and I just decided now to reinstall my Apache and PHP with Wamp, instead of just using the old ones that I installed.

Tagged :

Linux HowTo: How do I make my virtual host available to public?

Original Source Link

Im using a WAMP server to host a opencart store and I created a virtual host for it. When I type opencart/ in my browser it points me correctly to my site. So the website is working as I want. I want to make my site accessible to anyone. I want to use a DDNS server for my website. What are the steps I should take to get it up and running and point my DDNS to my virtual host and port? I am currently using DUC (No-ip) for my ddns

ngrok can do this for you: https://ngrok.com/
Install, sign up for an account, and refer to https://ngrok.com/docs#http to set up an http tunnel via ngrok servers.
This youtube video sums up all you need to do : https://www.youtube.com/watch?v=DCxt9SAnkyc

Tagged : / /

Making Game: How do I make my virtual host available to public?

Original Source Link

Im using a WAMP server to host a opencart store and I created a virtual host for it. When I type opencart/ in my browser it points me correctly to my site. So the website is working as I want. I want to make my site accessible to anyone. I want to use a DDNS server for my website. What are the steps I should take to get it up and running and point my DDNS to my virtual host and port? I am currently using DUC (No-ip) for my ddns

ngrok can do this for you: https://ngrok.com/
Install, sign up for an account, and refer to https://ngrok.com/docs#http to set up an http tunnel via ngrok servers.
This youtube video sums up all you need to do : https://www.youtube.com/watch?v=DCxt9SAnkyc

Tagged : / /

Linux HowTo: Aestan Tray Menu “could not execute menu item (internal error)”

Original Source Link

I get this message when I try running WAMP:

Could not execute menu item (internal error)
[Exception] Could not execute run action:
The system cannot find the file specified.

It stops me from opening WAMP. I went into Command Prompt and I typed iisreset /stop and I think that caused this error to happen. I tried iisreset /start but it says it failed to start. How can I fix this?

I had the same issue. I reinstalled wamp to solve the issue. This may help you reinstall wamp without losing data

Tagged :

Making Game: Aestan Tray Menu “could not execute menu item (internal error)”

Original Source Link

I get this message when I try running WAMP:

Could not execute menu item (internal error)
[Exception] Could not execute run action:
The system cannot find the file specified.

It stops me from opening WAMP. I went into Command Prompt and I typed iisreset /stop and I think that caused this error to happen. I tried iisreset /start but it says it failed to start. How can I fix this?

I had the same issue. I reinstalled wamp to solve the issue. This may help you reinstall wamp without losing data

Tagged :

Linux HowTo: WAMP MySQL Service will not start

Original Source Link

I did a fresh install of WAMP (v2.1) and it works excep the MySQL isn’t starting…. here:

enter image description here

and everytime I press “Start/Resume Service”, NOTHING happens.

I go to my.ini and put in a password.Then go to MySQL console.. type in that password and either 1. the console dissapeares or 2. I get Error 2003 “Can’t connect to MySQL server on ‘localhost’ (10061)”

Error No. 2003: Can’t connect to MySQL server on ‘localhost’ (or some other host)

simply means that connection is not possible for one of the following (or similar) reasons:

  • There is no MySQL server running at the specified host

  • Connection to the MySQL server is not allowed using TCP-IP. Check the ‘skip-networking’ setting in the MySQL configuration file (my.ini on Windows, my.cnf on Unix/Linux). It shall be commented out like ‘#skip-networking’. If it is not commented out, then do it and restart the MySQL server for the change to take effect.

  • Some networking issue prevents connection. It could be a network malconfiguration or a firewall issue. You need to allow the service mysql on windows firewall/ after you install wamp, restart ur pc. and start wamp

windows will ask is msqlnt.exe allowed to run and accept it
then its fine.

If it doesn’t work then:

Try turning off the windows firewall – if that fixes the problem, then turn it back on, and allow access to TCP/3306(default port)

  • When trying to connect to a MySQL server at an ISP this error message often indicates that direct connection to MySQL has been blocked. You must then use HTTP-tunneling or SSH-tunneling to connect.

I tried going to:
C:wampbinmysqlmysql5.6.17data
and deleted the following:

auto.cnf, xxxxxxxxx.err, xxxxxxxxx.pid, ib_logfile0 and ib_logfile1

But I left the ibdata1 alone as it references all local databases. I then restarted wamp and it worked like a charm.

Search for mysql-bin.index file, delete it, then restart MySQL.
This worked for me 😉

Please check the port that MySQL is using on your system. Then, change the port number of the WAMP server’s MySQL service to that number by entering it in my.ini.

If you’re running Windows, make sure to restart service and it immediately turns green.

I ran into a similar problem.

I had the exact same problem but my situation was different (I use WAMP 3.1 i.c.w. Windows 10 64-bit). Thus, the solution was different. Read below how I solved it in my situation.

First, I checked the MySQL Log. Like this:

Check the MySQL log

Second, I saw errors like this:

wampmysqld64: Table 'mysql.plugin' doesn't exist
2018-08-15T14:54:37.207560Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-08-15T14:54:37.211344Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-08-15T14:54:37.215551Z 0 [Warning] Failed to open optimizer cost constant tables

2018-08-15T14:54:37.216151Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

Third, after interpreting the errror log I navigated to the mysql data directory.
The location of that directory on my machine was: C:wamp64binmysqlmysql5.7.19data. This can be different on your machine. I noticed that some directories where missing. I didn’t had a “mysql” directory, though it must be there in order to work.

Fourth, I copied the “mysql” directory from a different machine to C:wamp64binmysqlmysql5.7.19data, and restarted All Services through WAMP. That solved the problem.

A previous mysql installation may cause this problem. Go to task manager and kill the mysqld.exe process. Then restart all the services. Good luck.

This will definitely work.

BEFORE proceeding with the installation of Wampserver, you must ensure that certain elements are installed on your system, otherwise Wampserver will absolutely not run, and in addition, the installation will be faulty and you will need to remove Wampserver BEFORE installing the elements that were missing.

Uninstall wamp and download and Install Microsoft Visual C++ redistributable 2008, Microsoft Visual C++ redistributable 2012 and Microsoft Visual C++ redistributable 2015. Now, reinstall wamp, and it should work fine.

Tagged : / / /

Making Game: WAMP MySQL Service will not start

Original Source Link

I did a fresh install of WAMP (v2.1) and it works excep the MySQL isn’t starting…. here:

enter image description here

and everytime I press “Start/Resume Service”, NOTHING happens.

I go to my.ini and put in a password.Then go to MySQL console.. type in that password and either 1. the console dissapeares or 2. I get Error 2003 “Can’t connect to MySQL server on ‘localhost’ (10061)”

Error No. 2003: Can’t connect to MySQL server on ‘localhost’ (or some other host)

simply means that connection is not possible for one of the following (or similar) reasons:

  • There is no MySQL server running at the specified host

  • Connection to the MySQL server is not allowed using TCP-IP. Check the ‘skip-networking’ setting in the MySQL configuration file (my.ini on Windows, my.cnf on Unix/Linux). It shall be commented out like ‘#skip-networking’. If it is not commented out, then do it and restart the MySQL server for the change to take effect.

  • Some networking issue prevents connection. It could be a network malconfiguration or a firewall issue. You need to allow the service mysql on windows firewall/ after you install wamp, restart ur pc. and start wamp

windows will ask is msqlnt.exe allowed to run and accept it
then its fine.

If it doesn’t work then:

Try turning off the windows firewall – if that fixes the problem, then turn it back on, and allow access to TCP/3306(default port)

  • When trying to connect to a MySQL server at an ISP this error message often indicates that direct connection to MySQL has been blocked. You must then use HTTP-tunneling or SSH-tunneling to connect.

I tried going to:
C:wampbinmysqlmysql5.6.17data
and deleted the following:

auto.cnf, xxxxxxxxx.err, xxxxxxxxx.pid, ib_logfile0 and ib_logfile1

But I left the ibdata1 alone as it references all local databases. I then restarted wamp and it worked like a charm.

Search for mysql-bin.index file, delete it, then restart MySQL.
This worked for me 😉

Please check the port that MySQL is using on your system. Then, change the port number of the WAMP server’s MySQL service to that number by entering it in my.ini.

If you’re running Windows, make sure to restart service and it immediately turns green.

I ran into a similar problem.

I had the exact same problem but my situation was different (I use WAMP 3.1 i.c.w. Windows 10 64-bit). Thus, the solution was different. Read below how I solved it in my situation.

First, I checked the MySQL Log. Like this:

Check the MySQL log

Second, I saw errors like this:

wampmysqld64: Table 'mysql.plugin' doesn't exist
2018-08-15T14:54:37.207560Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-08-15T14:54:37.211344Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-08-15T14:54:37.215551Z 0 [Warning] Failed to open optimizer cost constant tables

2018-08-15T14:54:37.216151Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

Third, after interpreting the errror log I navigated to the mysql data directory.
The location of that directory on my machine was: C:wamp64binmysqlmysql5.7.19data. This can be different on your machine. I noticed that some directories where missing. I didn’t had a “mysql” directory, though it must be there in order to work.

Fourth, I copied the “mysql” directory from a different machine to C:wamp64binmysqlmysql5.7.19data, and restarted All Services through WAMP. That solved the problem.

A previous mysql installation may cause this problem. Go to task manager and kill the mysqld.exe process. Then restart all the services. Good luck.

This will definitely work.

BEFORE proceeding with the installation of Wampserver, you must ensure that certain elements are installed on your system, otherwise Wampserver will absolutely not run, and in addition, the installation will be faulty and you will need to remove Wampserver BEFORE installing the elements that were missing.

Uninstall wamp and download and Install Microsoft Visual C++ redistributable 2008, Microsoft Visual C++ redistributable 2012 and Microsoft Visual C++ redistributable 2015. Now, reinstall wamp, and it should work fine.

Tagged : / / /