Tag: MySQL
PHP MySQL Connect to Database PDO
Below is a sample PHP code, that after configuration, can be used to connect to your database.
<?php
$DBType = "mysql";
$DBHost = "database-host";
$DBPort = "3306";
$DBEnco =...
MySQL Commands
Some of the most important SQL commands
Connect to MySQL Server:
mysql -u UserName -p
Show Users:
SELECT user FROM mysql.user;
Show Users and Hosts:
SELECT user,host FROM mysql.user;
Change Password...
mysqldump Backup Database and mysql Restore Database
Below are examples of backing up databases and examples of restoring database backups.
Backup:
mysqldump -u -p > /path/to/file.sql
Restore:
mysql -u -p <...
MySQL Connect Query Select Search Insert Update Delete
MySQL Connect
<?php
$mysqli = new mysqli("host", "username", "password", "dbname", "port", "socket");
if($mysqli -> connect_errno) {
echo "MySQL Connection Error: " . $mysqli -> connect_error;
exit();
}
?>
MySQL Query:
If you have...
