How to access WAMP MySQL from Command line

Are you looking for a way to access WAMP MySQL from command line? Our experts have the answer, Read on to learn more. Our MySQL Support Services team is here to offer a lending hand with your queries and issues.

How to access WAMP MySQL from command line

WAMP stands for Windows, Apache MySQL, and PHP. It is a variation of LAMP for systems running Windows. WAMP is often installed as a bundle. Furthermore, it is used for web development as well as internal testing. In some cases, it is also used to serve live websites.

Today, our in-house experts are going to demonstrate how to access WAMP MySQL from command line.

Option 1: 

1. First, run the cmd command.
2. Then, switch to the drive where we have installed the WAMP server. For instance, if it is installed in C drive, enter the following command:

   C:Copy Code
3. Then run the following commands:

   C:\>cd wamp
   C:\wamp>cd bin
   C:\wamp\bin>cd mysql
   C:\wamp\bin\mysql>cd mysql15.1.36
   C:\wamp\bin\mysql\mysql15.1.36>cd bin
   C:\wamp\bin\mysql\mysql15.1.36\bin>mysql.exe -u rootCopy Code

Now, we will be able to run MySQL on the command line with WAMP.

Option 2:

Alternatively, we can import a MySQL database via the command prompt in WAMP. Let’s take a look at how it is done:

1. First, open the command line.
2. Then, copy the MySQL path from the bin folder and set the path in the command line. For instance, C:\wamp\bin\mysql\mysql15.1.36\bin.
3. Next, run MySQL in the command line with the following command:

   MySQL -u root -pCopy Code

   .
4. This will prompt us for the MySQL root password.
5. After that, create a new database with the following command:

    CREATE DATABASE dbnameCopy Code

   where we have to replace dbname with the new database name.
6. Next, run the following command to import tables:

   USE dbnameCopy Code
7. Then, copy the path of the database from where we want to import the database and run this command:

    Database_source [path to sql] – source database_folder_path\database_nameCopy Code

   This will import the MySQL database we require.

If you prefer a shortcut method to access WAMP MySQL from command line, our experts have your back. You can run the following command to import a database with a single step:

mysql_bin_folder>mysql -u username -p database_name < database_sourceCopy Code

Now, we will be prompted to enter a password. After entering the correct password, the related database tables are imported successfully.

Let us know in the comments which method worked for you.

[Need assistance with a different issue? Our team is available 24/7.]

Conclusion

To sum up, we got a firsthand look at how to access WAMP MySQL from the command line with this step-by-step guide by our experts.