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,181 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,921 total views, no views today

How to Restart MySQL Service Using Linux Shell Command Line

Linux Shell Commands

Why you need to Restart SSH Service Sometimes you may need to change some configurations inside MySQL configuration file my.cnf , so after you made or modify the MySQL cnf file ,properly you need to Stop and Start or Restart MySQL Service. How To  Restart MySQL Service under Linux / UNIX…

Continue reading

1,654 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,497 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,540 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,491 total views, no views today