Thursday, June 29, 2017

Create, Backup and Restore MYSQL Database in Linux

Create, Backup and Restore MYSQL Database in Linux



Create new database using terminal

[root@localhost]# mysql -u root -p
mysql> create database 1234;
mysql> grant all privileges on web.* to web@localhost identified by "1234";
mysql> show datadbase;

Backup database using terminal

.....

No comments:

Post a Comment

Oracle Database 19c Installation on Oracle Linux 7

Pre-installation settings before installing Oracle Database 19c SELinux If the OS is to be used for an Oracle installation, it is ...