mysql> show databases; Let’s take it a few steps further. Next, select one of the databases. mysql> use database_name; Now show all data tables. mysql> show tables;
If you installed from the official MySQL package from Mac OS X you can use this command in Terminal: /usr/local/bin/mysql.server start
DROP USER yourusername Official MySQL Reference for the Drop User Command.
Enable Remote Connection Edit /etc/mysql/my.cnf Basic Editing Options: 1. Less secure, most accessible: Comment out bind-address 2. More secure, less accessible: change bind to your server’s IP address Save and exit. $ sudo service mysql restart Grant Access to your … Continued
Dump the orginal MySQL database, and put it into the folder you’re working in on the new server. Create a new databse with a new name. Create a new user, with the same user name and password used in the … Continued
Back up your database from the command line using mysqldump. This works in most Linux based terminals / SSH.
$ mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql]
[uname] Your database username [pass] The password for your database (note there is no space between -p and the … Continued
Note: These instructions will actually work for most MySql connection, not just WordPress. When you are developing a WordPress theme, it’s best to work on it offline. Many times you do not want to have to download the entire MySQL … Continued