Now, run mysql_command.bat and a command prompt will show up with the MySQL command line running. But it gives the below error: ERROR 2003 (HY000): Can't connect to MySQL server on 'my. I have tried like below: mysql-u username-h my.-ppassword. Save it, and change the –user= and –password= if you’ve changed the user or password. I am trying to access the database from the command line of my local machine. Mysql\bin\mysql.exe -user=root -password= First, create a file called mysql_command.bat in the XAMPP directory.Edit this file with Notepad or any text editor, and paste in this: offecho Starting MySQL command line. If you’ve changed the username or password of the MySQL user, you need to change the –user= and –password= accordingly.īasically the same way as before, but we’ll create a batch file to make it easier. Once in there, cd to the mysql bin directory.Īnd the MySQL command line will start. If you used the installer and default install location. Start the command prompt, and cd to the xampp directory. Both are basically the same, but one just makes it a lot easier. This is from version 1.6.0a of XAMPP and lighttpd is 1.4.13 from here. XLMPP –> XLMPP is XAMPP, but instead of Apache, it uses lighttpd.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |