Drop User MySQL
in MySQL
0
0DROP USER yourusername Official MySQL Reference for the Drop User Command.
MySQL
Remote MySQL Connection on Ubuntu
in MySQL
0
0Enable 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
Importing MySQL dump of WordPress database from terminal
in MySQL
740
740Dump 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
MYSQL Dump from Command Line
in Linux
785
785Back up your database from the command line using mysqldump. This works in most Linux based terminals / SSH.
|
1 |
$ 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
Establishing a remote database connection for local WordPress development
in MySQL
631
631Note: 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