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

831 total views, 1 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,555 total views, no 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,024 total views, 2 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,194 total views, 4 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,185 total views, 1 views today