![phpmyadmin mamp for windows phpmyadmin mamp for windows](https://cdn.timmyomahony.com/assets/screenshot_2019-03-15_at_212306.png)
![phpmyadmin mamp for windows phpmyadmin mamp for windows](https://kinsta.com/wp-content/uploads/2021/05/mamp-phpmyadmin-config-inc.jpg)
Phpmyadmin mamp for windows password#
Another thing, if you did not set a root password for your database server, you can omit the option -p You can check this by navigating to your c:\wamp64\bin\ directory. Make sure the database name (such as mariadb10.3.23 or mysql8.0.21) matches your own version. If you are using MySQL, then type: C:\wamp64\bin\mysql\mysql8.0.21\bin\mysqldump -uroot -p > \.sql Open up your command prompt (in taskbar search box, type: cmd) and type: C:\wamp64\bin\mariadb\mariadb10.3.23\bin\mysqldump -uroot -p > \.sql We can use the mysqldump utility to export any database. You can now go check your phpmyadmin to see if the database has been imported. Note: use forward slash in your path (ie, / ) for example if your sql database file is in the root of your C: drive, type C:/my_new_database.sql
![phpmyadmin mamp for windows phpmyadmin mamp for windows](https://kinsta.com/wp-content/uploads/2021/05/mamp-phpmyadmin-not-working-featured-image-1200x675.jpg)
Replace full_path_to_your_db with your own path. Next, type: source full_path_to_your_db/my_new_database.sql It should print out a message 'Database changed' on the console. Replace my_new_database with your own name of your newly created database and hit enter key. Otherwise, enter your root password to continue.Īfter the password prompt, you will be logged into your database console presented with this screen. If you did not set a password, you can just leave it blank and press enter key. The console will prompt you to enter a password. Click on 'create' button to create your new database.įor MariaDB user - Left-click on mampmanager icon -> MariaDB -> MariaDB consoleįor MySQL user - Left-click on mampmanager icon -> MySQL -> MySQL console In the dropdown list field next to it, select: utf8_general_ci (or utf8mb4_general_ci). Under the title 'Create database' there is a field, type in a name for your new database. To create a new database in phpmyadmin, login (if you have a password) and on the left sidebar with the tree view, click on new. We need this new database to import your sql file (which contains the database) into it. To import a database:įirst open up phpmyadmin and create a new blank database. I use MariaDB on Wamp. If you use MySQL, it's no different.
Phpmyadmin mamp for windows windows#
So you need to revert back to the good old command line to import/export your database and here's how on Wamp for Windows 10. But unfortunately it cannot handle large databases. PHPMyAdmin can be a useful tool when it comes to managing your database.