how to use commandline for queries in wamp
Posted by: Javed (39.41.183.---)
Date: November 23, 2013 09:14AM

I had installed wamp on win7 platform having apache 2.4.4 ,mysql5.6.12,php5.4.12. and started using it by cilcking phpmyadmin it works fine from them...How to use it from command line to insert queries from there as i already employed wamp>bin>mysql>mysql5.6.12>bin>mysql.exe and when enters "SELECT Host,User,Password FROM Mysql.user; it prompts:
ERROR 1142(42000)confused smileyELECT command denied to user ''@'localhost' for table 'user'
PLz guide me for this to able to use commandline for mysql

Options: ReplyQuote
Re: how to use commandline for queries in wamp
Posted by: RiggsFolly (---.as13285.net)
Date: November 23, 2013 11:20PM

Try

>wamp>bin>mysql>mysql5.6.12>bin>mysql.exe -u root -p

It will then ask for a password
Just hit enter ( unless you have added a password to the 'root' userid.



Of course if all else fails you could always try reading the Manual
[dev.mysql.com]

---------------------------------------------------------------------------------------------
(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-

Options: ReplyQuote


Sorry, only registered users may post in this forum.