How To Create MySQL database with SSH command in Php.?
Creating a MySQL database via SSH:- First of all you need to have the server root access to begin creating database using the SSH command line. Then follow the steps to create database using the SSH command line.
Here are the steps to create the Database and user by using the SSH Command.
ssh username@hostname
mysql -u root -p
-u is the user and -p stands for password to complete the login for mysql.
CREATE DATABASE your_database;
CREATE DATABASE IF NOT EXISTS your_database;
GRANT USAGE ON database_name.* to new_user@localhost IDENTIFIED BY 'user_passwd';
GRANT ALL ON your_database.* to user@localhost;
flush privileges;
mysql -u new_user -p 'user_passwd' your_database
exit;
To View All Your Created Database:-
SHOW DATABASES;
mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | your_database | +--------------------+
How to Select Your Database?
To select a database use the following command:-
USE your_db_name;
Hope this will be helpful, Thanks and Enjoy the PHP Coding.
