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…
//
Author: admin
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…
Programming
Create JSON Files In PHP
Format the data values using the function json_encode(), and generate the JSON file with the use of the following functions, fopen(), fwrite(), and fclose()…
Programming
Differentiate bindParam From bindValue
The main difference between PDOStatement bindParam() and PDOStatement bindValue() is that when using the former, the variable is bound as a reference and will…
Programming
Use PHP PDOStatement bindValue
Use the PDO function PDOStatement bindValue() to bind a parameter to a specified variable name in PHP. Requirements: PHP PHP Data Objects PDO Drivers…