mysql console not executing (won't launch, cant getpast username input)
Posted by: agm_thanks4urhelp (---.hfc.comcastbusiness.net)
Date: March 31, 2020 07:17PM

1 - Windowsw version - Windows 10 Pro, v1909, 64bit
2 - Version WampServer - 3.2.0, 64 bit
3 - Apache Version - 2.4.39
4 - PHP Version - 7.2.18
5 - MySQL Version - 5.7.26
5a - MariaDB version if applicable - 10.3.14
6 - What color is the WampServer icon GREEN
7 - N/A
8 - Do you have access to localhost? YES
8a - If so, is there an error message at the bottom of the page? NO
9 - Do you have access to phpMyAdmin? YES
10 - If you refer to an error message, please include the EXACT wording of the error in your post. DONE
11 - If you use an Antivirus and / or Firewall, please include the names of these. Avast, Malwarebytes
12 - What is the full path to the installation of WampServer - "C:\wamp64"
13 - If you have one or more Virtual Hosts defined, please show their definition(s). THIS IS WORKING:
# Virtual Hosts
#
<VirtualHost *:80>
ServerName localhost
ServerAlias localhost
DocumentRoot "${INSTALL_DIR}/www"
<Directory "${INSTALL_DIR}/www/">
Options +Indexes +Includes +FollowSymLinks +MultiViews
AllowOverride All
Require local
</Directory>
</VirtualHost>



<VirtualHost *:80>
ServerName chi-wordpress.local
ServerAlias www.chi-wordpress.local
DocumentRoot "${INSTALL_DIR}/www/chi-wordpress"
<Directory "${INSTALL_DIR}/www/chi-wordpress/">
Options +Indexes +Includes +FollowSymLinks +MultiViews
AllowOverride All
Require local
</Directory>
</VirtualHost>


---


Hello everyone

When attempting to open MySQL Console either through the system tray or navigating via command line, I am prompted to enter my enter my username (root), however instead of asking for my password i get this error message:


Could not execute run action: %1 is not a valid Win32 application
Action : Run
Filename: c:/wamp64/bin/mysql/mysql5.7.26/bin/mysql.exe
Parameters: -u %MysqlUser% -p


Trying to import a large db, as you all know, phpMyAdmin is very slow in comparison.

I'm not able to find any answers as to why this is occurring specifically with wamp/mysql, but I understand there may be a mix up in regard to a 32bit application on a 64bit pc? Did not quite understand this.

I've tried upgrading to the latest version of wamp to no avail.

MariaDB console works, but I am unfamiliar with it.

Thanks for any help, happy to provide more info or screenshots if that will help clear anything up.

---

Noticed that mysql.exe is 0kb



Edited 2 time(s). Last edit at 03/31/2020 10:15PM by agm_thanks4urhelp.

Options: ReplyQuote
Re: mysql console not executing (won't launch, cant getpast username input)
Posted by: Otomatic (Moderator)
Date: March 31, 2020 07:29PM


Options: ReplyQuote
Re: mysql console not executing (won't launch, cant getpast username input)
Posted by: RiggsFolly (Moderator)
Date: April 01, 2020 12:37PM

Hi,

What happens when you open a command windows and navigate to the mysql processor, like this

cd \
cd c:\wamp64\bin\mysql\mysql5.7.26\bin
mysql -u root -p

What errors, if any do you get then?

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 1 time(s). Last edit at 04/01/2020 01:54PM by Otomatic.

Options: ReplyQuote


Sorry, only registered users may post in this forum.