Set mysql root password after new installation on Linux

MySQL Article

Set mySQL root password If you install a fresh MySQL database server on Linux, the root account within MySQL has no password set yet. To set the root password : first login to your server using ssh as administrator privileges and  Issue the following command: /usr/bin/mysqladmin -u root password ‘your-new-password’…

Continue reading

1,064 total views, no views today

How to create User and Grant Permission In MySQL on Linux Command Line

Linux Article

MySQL Linux Commands We are going to take a quick tour of common Linux command to deal with MySQL database: Login to MySQL in Linux using command line To login to MySQL database run the following command: mysql -u root -p Enter password: mysql> By passing -u parameter as login…

Continue reading

1,839 total views, 1 views today

How to Create/Remove MySQL or MS SQL Database in Plesk

Plesk Databases

How to create MySQL Database in Plesk Login to your Plesk control Panel. From Website & Domains Tab click Add Database Button. From the Add a Database Page type the following: Database name: type your unique database name. Database server : for MySQL Server select MySQL from drop down list.…

Continue reading

1,336 total views, no views today

How to Import Export MySQL database using SSH connection

MySQL Article

Commands on Linux to Import/Export MySQL Frist login to your server using SSH then you have to run some commands for import/export MySQL database Note:you need to know the database username and password to simulate an exmaple lets consider the following: dbusername: cpnluser_user as a database user example, cpnluser as…

Continue reading

1,450 total views, no views today

How to Import Export MySQL database using phpMyAdmin

MySQL Article

What is phpMyAdmin phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the…

Continue reading

1,389 total views, no views today