Mysql
Installation:
sudo apt-get install mysql-server
Login as root
mysqladmin -u root -p
Create a Database:
mysqladmin -u root -p create testdb
Check Databases:
mysql -u root -p show databases;
Select a Database:
use testdb;
Creating a user:
This section is under construction. |
Connecting to a database directly:
mysql testdb -u user -pmypassword
Granting access to the Databse:
This section is under construction. |
Export DB
mysqldump testdb > testdb.sql -p
Import DB
mysql testdb < /var/www/html/test.com/testdb.sql -p
The default port of the database server is 3306
If you are unable to connect to the database, try disabling the IPTables:
iptables -F