Q:

Changing the root user of MySQL

How do I change my root user to any other local user on mysql db?Since I have installed Ubuntu all the work is done by this superuser root now just don't want root to do all stuff of mysql...

A:

You do not need to change the root user. 
For purpose of data operations we usually create a new mysql user and grant certain  privileges to this user (generally limited to a database).
This can be done in following ways:

From terminal

mysql -u root -p
and enter the root password. Then, in the terminal you will see as mysql> indicating you are logged in as root in mysql.
Now you can create/modify users. For creating users,
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
then you can grant some prvileges to this new user by,
GRANT ALL ON database_name.table_name TO 'username'@'localhost';
and you can check privileges by SHOW GRANTS FOR 'username'@'localhost';
This is a very general description and refer to the manual here for details. MySQL man page for creating/modifying user

phpmyadmin

This is a browser based tool which allows for doing all the user-management and database management job in one place.
After installation and configuration of this tool, phpmyadmin can be accessed in the local computer as  http://localhost/phpmyadmin . After login (as root or as  a specific user), management operations can be performed.
Please refer to other links about installation and usage.
Official page phpMyAdmin

