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 […]
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 […]
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 […]
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 […]