How to Install PHPMyAdmin on CentOS 6?
IntroductionPHPMyAdmin is an open source tool used in place of MySQL command with graphical and more intuitive way of performing administration tasks like creating,editing, or deleting databases, and managing users with permissions. In the below article lets see how to install PHPMyAdmin on CentOS server.PrerequisitesI will be working on a Fastwebhost managed CentOS 6.6 server.Initially for […]
MySQL List Users – How to List MySQL User Accounts via command line?
You are using the MySQL Database server and created database and users. Now you need to see MySQL users list. How can you view users? In this tutorial, you will see how to list MySQL user accounts via command line.Login to MySQL ServerOnce you are in Linux / Ubuntu command line enter below command to […]
How To Create a MySQL User and Grant Permissions in MySQL via Command Line
Let’s see how to create a MySQL user and grant permissions to the database. All through the command line only. First, you need to login to MySQL server to create users and assigning privileges.Login to MySQL ServerOnce you are in Linux / Ubuntu command line enter below command to access MySQL server.shell> mysql –user=root mysqlThe above […]
How to Change or Reset MySQL root Password via Command Line
In this tutorial you are going to learn how to change or reset MySQL root password via command line on Linux/Ubuntu server. There are situations where you need to change password for root user or any database user. MySQL Database Command Line Basics How to Change or Reset MySQL root Password via Command LineHow to […]