Category: MySQL
How to create a New Database-user and Grand Permissions – MySQL
Enter the mysql prompt by following the step below: It then prompts for password. Enter the MySQL root password. Command to Grand All privileges on DB for a user. how to add SELECT privileges to a user using GRANT. how to add a selection of privileges to a user using GRANT.
Allow mysql client to access remote mysql databases
One thing you must understand is that mysql server only allow localhost connections by default. So what does that mean ? Before going deep let me put up an example mysql-server. (1) ” Consider abc.com (5.5.5.5) is our mysql-server and is hosted on a VPS machine. We have setup a lamp environment on 5.5.5.5 and
Reset mysql root password from command line
Stop mysql server Start mysql configuration, Execute the command as mysql safemode: Replace old password with the new one from mysql command prompt. Restart mysql server. Access mysql by using new password
Restore a dump file from mysqldump?
To get a list of all MySQL user accounts, use the SELECT statement to retrieve all rows from the mysql.users table: Backup a Single MySQL Database: Backup all MySQL databases to separate files: Create a Compressed MySQL Database Backup: Create a Backup with Timestamp: Restoring a MySQL dump : Restoring using MySQL Prompt, using source: On the command-line, if you’re