Database Administration
Tutorials
-
Restore MySQL backup from the terminal
Efficiently import MySql backup database records from an .sql file using the mysql command from the terminal. A quick and direct approach to restore MySQL […]
-
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 perform […]
-
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 […]
-
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 the […]
-
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 design […]
-
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 search […]