Why no privileges in phpmyadmin

I am using Ubuntu I want to create a MySQL user "root" with full privileges to do everything. How can I resolve my problem?

Improve this question. FrontIm1 FrontIm1 11 1 1 gold badge 1 1 silver badge 3 3 bronze badges. Lets confirm, is there any root user? Add a comment. Active Oldest Votes. In three steps: sudo systemctl stop mysql sudo dpkg-reconfigure mysql-server Improve this answer. Marc Vanhoomissen Marc Vanhoomissen 1, 5 5 gold badges 16 16 silver badges 31 31 bronze badges.

While typing sudo dpkg-reconfigure mysql-server , use Tab keys to foreseen what's the mysql-server installed. Sometimes you may have installed mariadb-server instead of mysql.

Try to Login user root and password same you are using with your Mysql User Phpmyadmin panel will open and follow the steps: 1 goto users 2 check if your user exists for mysql users User Host Password Global privileges Grant Action 3 click on Edit Privileges for specific user 4 Check Mark all global Privileges and Go 5 Login with your current user It will access to create and allow permission Thanks..!!

Atieq ur Rehman Atieq ur Rehman 11 3 3 bronze badges. Unfortunately I am unable to login as root. Ubuntu for example has the following 2 lines; if! Did this post show you the way Was this post helpful Votes: 0 0. Was this post useless Votes: 0 0. Have you had the same problem Votes: 0 0. Did this post help you overcome the same problem Votes: 0 0. Total voters 0 Poll closed Dec 19, GlasgowGuy Neophyte. Joined Dec 4, Messages 1. I have been on a couple of forums abut nothing really is added to make me understand the help, so please bear with me as I'm classed right now as a novice, if that.

I've just started studying PHP and I'm onto databases. The situation I'm in the now is that I log into phpmyadmin and then I click through to databases, up to here everything is well. Then once I'm in I want to create a database but underneath there is text in red which is "no privileges". Now I use Xampp so I know it means I don't have privileges on my own computer to make a database.

So where do I find the file to do the changes, and once found what and where do I add in the file? To log into phpmyadmin the Username: user and the Password is left blank. All I need is, nothing much loll 1. Where is the location of the file I have to change? What is the name of the file I have to change? What exactly do I have to type and where on the file? You get to choose every single program and package that is installed on the machine and even pick the operating system itself!

The only downside to using a Virtual Private Server is the fact that good working knowledge of Linux is required. The vast majority of VPS instances run Linux distributions that lack a graphical user interface in order to maximize performance. In other words, you need to be comfortable completely managing and maintaining your VPS through the command line.

Using a Virtual Private Server for your hosting needs would resolve many of these issues and points of friction. Not having fine-grained control over your hosting space, including database management, and not being able to import an SQL backup in phpMyAdmin because it tries to create a database during its restoration process will all be a thing of the past.

We use cookies to ensure you can get the best experience on our site. If you keep using this site we assume that you agree to our use of cookies. Privacy Policy OK. A Getting Started Guide Back. Published on September 26th,