Database Administration
Grant Privileges to MySQL User
Assign privileges and roles to MySQL user accounts and roles using MySQL GRANT statement. This is to be able for a MySQL user to…
//
Category: Database Administration
Database Administration
Create MySQL Database User
Create a MySQL user with password to access a MySQL database from a specific host to do things like adding, updating, deleting, and listing…
Database Administration
Access MySQL Database From Terminal
Directly access a MySQL database from the terminal. Connect with the given username, password, and host straight from the command line. Know more about…
Database Administration
Update MySQL Records Using Replace Function
Update DATABASE records directly using the REPLACE() function in MySQL. No scripting or programming language needed. Can be executed in any MySQL visual database…
Database Administration
Replace A String In MySQL
Use the MySQL string function REPLACE() to replace occurrences of a specified string. It will return the original string with all occurrences of the…
Database Administration
Backup MySQL Database In Terminal
Import MySql database records into an .sql file from the terminal using the MySql command mysqldump, it is a quick and easy way to…