Unable to login to phpmyadmin with the root user
I have a root user in mysql-server on the Ubuntu server. I am unable to login to phpmyadmin with the root user and password. I was trying to find the configuration file but could not locate it. Help would be appreciated.
Thanks in advance
server phpmyadmin
edited Apr 10 '11 at 18:59
Jorge Castro
36.1k105422617
asked Apr 10 '11 at 18:57
user14010user14010
156115
add a comment |
I have a root user in mysql-server on the Ubuntu server. I am unable to login to phpmyadmin with the root user and password. I was trying to find the configuration file but could not locate it. Help would be appreciated.
Thanks in advance
server phpmyadmin
edited Apr 10 '11 at 18:59
Jorge Castro
36.1k105422617
asked Apr 10 '11 at 18:57
user14010user14010
156115
Did you ever find the answer to this problem? I'm having problems myself as well.
– chrisjlee
Oct 10 '11 at 2:03
add a comment |
I have a root user in mysql-server on the Ubuntu server. I am unable to login to phpmyadmin with the root user and password. I was trying to find the configuration file but could not locate it. Help would be appreciated.
Thanks in advance
server phpmyadmin
edited Apr 10 '11 at 18:59
Jorge Castro
36.1k105422617
asked Apr 10 '11 at 18:57
user14010user14010
156115
I have a root user in mysql-server on the Ubuntu server. I am unable to login to phpmyadmin with the root user and password. I was trying to find the configuration file but could not locate it. Help would be appreciated.
Thanks in advance
server phpmyadmin
server phpmyadmin
edited Apr 10 '11 at 18:59
Jorge Castro
36.1k105422617
asked Apr 10 '11 at 18:57
user14010user14010
156115
edited Apr 10 '11 at 18:59
Jorge Castro
36.1k105422617
asked Apr 10 '11 at 18:57
user14010user14010
156115
edited Apr 10 '11 at 18:59
Jorge Castro
36.1k105422617
edited Apr 10 '11 at 18:59
Jorge Castro
36.1k105422617
edited Apr 10 '11 at 18:59
Jorge Castro
36.1k105422617
36.1k105422617
asked Apr 10 '11 at 18:57
user14010user14010
156115
asked Apr 10 '11 at 18:57
user14010user14010
156115
asked Apr 10 '11 at 18:57
user14010user14010
156115
156115
Did you ever find the answer to this problem? I'm having problems myself as well.
– chrisjlee
Oct 10 '11 at 2:03
add a comment |
Did you ever find the answer to this problem? I'm having problems myself as well.
– chrisjlee
Oct 10 '11 at 2:03
Did you ever find the answer to this problem? I'm having problems myself as well.
– chrisjlee
Oct 10 '11 at 2:03
Did you ever find the answer to this problem? I'm having problems myself as well.
– chrisjlee
Oct 10 '11 at 2:03
add a comment |
8 Answers
8
active
oldest
votes
You have to reconfigure phpmyadmin, reset MySQL password.
- Reconfigure phpmyadmin
- Ctrl + Alt + T to launch terminal
- sudo dpkg-reconfigure phpmyadmin
- Connection method for MySQL database for phpmyadmin: unix socket
- Name of the database's administrative user: root
- Password of the database's administrative user: mysqlsamplepassword
- MySQL username for phpmyadmin: root
- MySQL database name for phpmyadmin: phpmyadmin
- Web server to reconfigure automatically: apache2
- ERROR 1045
- ignore
- sudo dpkg-reconfigure mysql-server-5.5
- New password for the MySQL "root" user: mysqlsamplepassword
- Repeat password for the MySQL "root" user: mysqlsamplepassword
Wish it helps!
Have a nice day!
answered Aug 13 '12 at 7:27
Amigo ChanAmigo Chan
55956
After 5 years this reply helped me. I skipped steps 12,13 and 14 (raspbian lamp configuration)
– Jostino
Apr 13 '18 at 0:20
add a comment |
By "rootuser" you mean the MySQL root user, not the system root user, right?
During the installation of mysql-server, the MySQL root account is created and its password is stored in /etc/mysql/debian.cnf.
The configuration files of phpMyAdmin are stored in /etc/phpmyadmin.
answered Apr 10 '11 at 19:01
LekensteynLekensteyn
121k48266356
Yes, I mean MySQL root user and not the system root user.I found the config file. Why is phpmyadmin not allowing to log me in with the mysql user login
– user14010
Apr 10 '11 at 19:30
@user14010: Does the command-linemysqlversion work? E.g.mysql -hlocalhost -uroot -p?
– Lekensteyn
Apr 10 '11 at 20:57
Yes it works. I am able to login to mysql through command line version but not with phpmyadmin. The reason why I am trying to use phpmyadmin is I have a sql script when I am trying to import it using the commandline mysql it is creating problems with the foreignkeys resulting in error 121. When I import the same script uing phpmyadmin it succesfully creates the tables
– user14010
Apr 10 '11 at 21:11
@user14010: What error message did you get? I've updated my answer with the location of the PMA configuration files.
– Lekensteyn
Apr 11 '11 at 12:50
add a comment |
I encountered a similar problem in Ubuntu 14.04 using MariaDB. Instead of trying to change everything I just created a new user.
mysql -u root -p
Entered the root password
Created a new user using the following command:
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'some_very_complex_password';
Granted all permissions to newuser:
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
You can then log on using newuser in phpMyadmin. I would strongly encourage you to only grant specific privileges to newuser instead of Carte Blanche privileges but it's your own funeral.
answered Mar 29 '16 at 14:06
Garikai DzomaGarikai Dzoma
666
add a comment |
Might for some reason the AllowRoot option be set to False? See the documentation.
edited Jun 12 '18 at 21:04
bshea
42738
answered May 11 '11 at 19:08
loevborgloevborg
5,56211823
add a comment |
I recently came across a very similar issue with Ubuntu 12.04. I just couldn't seem to login with root & no password. I set the AllowNoPassword setting to TRUE in the config. Later I found out that I was editing the wrong config.inc.php file to add the AllowNoPassword setting.
Edit:
/etc/phpmyadmin/config.inc.php
Not:
/usr/share/phpmyadmin/config.inc.php
I believe the first is the debian local config file, which will override the usr version.
answered May 31 '12 at 1:24
jjwdesignjjwdesign
270112
add a comment |
I installed MySQL using synaptic manager. Didn't have to enter a root password.
The command:
mysqladmin -u root password NEWPASSWORD
worked. I was able to login into PhpMyAdmin immediately.
edited Feb 8 '16 at 23:06
incBrain
1,843919
answered Feb 8 '16 at 21:30
omariojaomarioja
1
add a comment |
To log in as root in phpmyadmin:
echo "UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket';FLUSH PRIVILEGES;" | mysql -u root -p
Found at the end of this tutorial
Worked for me :)
edited Sep 8 '18 at 5:19
Zanna
50.5k13133241
answered Sep 8 '18 at 4:55
RicRic
1
add a comment |
Me too,
echo "UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket';FLUSH PRIVILEGES;" | mysql -u root -p
This is good
answered Jan 15 at 14:17
Florian BizetFlorian Bizet
1
New contributor
Florian Bizet is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Please do not repost the same answer as already given. Instead, upvote the ones you found helpfull (once you have enough reputation)
– Marc Vanhoomissen
Jan 15 at 15:27
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f34409%2funable-to-login-to-phpmyadmin-with-the-root-user%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
8 Answers
8
active
oldest
votes
8 Answers
8
active
oldest
votes
active
oldest
votes
active
oldest
votes
You have to reconfigure phpmyadmin, reset MySQL password.
- Reconfigure phpmyadmin
- Ctrl + Alt + T to launch terminal
- sudo dpkg-reconfigure phpmyadmin
- Connection method for MySQL database for phpmyadmin: unix socket
- Name of the database's administrative user: root
- Password of the database's administrative user: mysqlsamplepassword
- MySQL username for phpmyadmin: root
- MySQL database name for phpmyadmin: phpmyadmin
- Web server to reconfigure automatically: apache2
- ERROR 1045
- ignore
- sudo dpkg-reconfigure mysql-server-5.5
- New password for the MySQL "root" user: mysqlsamplepassword
- Repeat password for the MySQL "root" user: mysqlsamplepassword
Wish it helps!
Have a nice day!
answered Aug 13 '12 at 7:27
Amigo ChanAmigo Chan
55956
After 5 years this reply helped me. I skipped steps 12,13 and 14 (raspbian lamp configuration)
– Jostino
Apr 13 '18 at 0:20
add a comment |
You have to reconfigure phpmyadmin, reset MySQL password.
- Reconfigure phpmyadmin
- Ctrl + Alt + T to launch terminal
- sudo dpkg-reconfigure phpmyadmin
- Connection method for MySQL database for phpmyadmin: unix socket
- Name of the database's administrative user: root
- Password of the database's administrative user: mysqlsamplepassword
- MySQL username for phpmyadmin: root
- MySQL database name for phpmyadmin: phpmyadmin
- Web server to reconfigure automatically: apache2
- ERROR 1045
- ignore
- sudo dpkg-reconfigure mysql-server-5.5
- New password for the MySQL "root" user: mysqlsamplepassword
- Repeat password for the MySQL "root" user: mysqlsamplepassword
Wish it helps!
Have a nice day!
answered Aug 13 '12 at 7:27
Amigo ChanAmigo Chan
55956
After 5 years this reply helped me. I skipped steps 12,13 and 14 (raspbian lamp configuration)
– Jostino
Apr 13 '18 at 0:20
add a comment |
You have to reconfigure phpmyadmin, reset MySQL password.
- Reconfigure phpmyadmin
- Ctrl + Alt + T to launch terminal
- sudo dpkg-reconfigure phpmyadmin
- Connection method for MySQL database for phpmyadmin: unix socket
- Name of the database's administrative user: root
- Password of the database's administrative user: mysqlsamplepassword
- MySQL username for phpmyadmin: root
- MySQL database name for phpmyadmin: phpmyadmin
- Web server to reconfigure automatically: apache2
- ERROR 1045
- ignore
- sudo dpkg-reconfigure mysql-server-5.5
- New password for the MySQL "root" user: mysqlsamplepassword
- Repeat password for the MySQL "root" user: mysqlsamplepassword
Wish it helps!
Have a nice day!
answered Aug 13 '12 at 7:27
Amigo ChanAmigo Chan
55956
You have to reconfigure phpmyadmin, reset MySQL password.
- Reconfigure phpmyadmin
- Ctrl + Alt + T to launch terminal
- sudo dpkg-reconfigure phpmyadmin
- Connection method for MySQL database for phpmyadmin: unix socket
- Name of the database's administrative user: root
- Password of the database's administrative user: mysqlsamplepassword
- MySQL username for phpmyadmin: root
- MySQL database name for phpmyadmin: phpmyadmin
- Web server to reconfigure automatically: apache2
- ERROR 1045
- ignore
- sudo dpkg-reconfigure mysql-server-5.5
- New password for the MySQL "root" user: mysqlsamplepassword
- Repeat password for the MySQL "root" user: mysqlsamplepassword
Wish it helps!
Have a nice day!
answered Aug 13 '12 at 7:27
Amigo ChanAmigo Chan
55956
answered Aug 13 '12 at 7:27
Amigo ChanAmigo Chan
55956
answered Aug 13 '12 at 7:27
Amigo ChanAmigo Chan
55956
answered Aug 13 '12 at 7:27
Amigo ChanAmigo Chan
55956
55956
After 5 years this reply helped me. I skipped steps 12,13 and 14 (raspbian lamp configuration)
– Jostino
Apr 13 '18 at 0:20
add a comment |
After 5 years this reply helped me. I skipped steps 12,13 and 14 (raspbian lamp configuration)
– Jostino
Apr 13 '18 at 0:20
After 5 years this reply helped me. I skipped steps 12,13 and 14 (raspbian lamp configuration)
– Jostino
Apr 13 '18 at 0:20
After 5 years this reply helped me. I skipped steps 12,13 and 14 (raspbian lamp configuration)
– Jostino
Apr 13 '18 at 0:20
add a comment |
By "rootuser" you mean the MySQL root user, not the system root user, right?
During the installation of mysql-server, the MySQL root account is created and its password is stored in /etc/mysql/debian.cnf.
The configuration files of phpMyAdmin are stored in /etc/phpmyadmin.
answered Apr 10 '11 at 19:01
LekensteynLekensteyn
121k48266356
Yes, I mean MySQL root user and not the system root user.I found the config file. Why is phpmyadmin not allowing to log me in with the mysql user login
– user14010
Apr 10 '11 at 19:30
@user14010: Does the command-linemysqlversion work? E.g.mysql -hlocalhost -uroot -p?
– Lekensteyn
Apr 10 '11 at 20:57
Yes it works. I am able to login to mysql through command line version but not with phpmyadmin. The reason why I am trying to use phpmyadmin is I have a sql script when I am trying to import it using the commandline mysql it is creating problems with the foreignkeys resulting in error 121. When I import the same script uing phpmyadmin it succesfully creates the tables
– user14010
Apr 10 '11 at 21:11
@user14010: What error message did you get? I've updated my answer with the location of the PMA configuration files.
– Lekensteyn
Apr 11 '11 at 12:50
add a comment |
By "rootuser" you mean the MySQL root user, not the system root user, right?
During the installation of mysql-server, the MySQL root account is created and its password is stored in /etc/mysql/debian.cnf.
The configuration files of phpMyAdmin are stored in /etc/phpmyadmin.
answered Apr 10 '11 at 19:01
LekensteynLekensteyn
121k48266356
Yes, I mean MySQL root user and not the system root user.I found the config file. Why is phpmyadmin not allowing to log me in with the mysql user login
– user14010
Apr 10 '11 at 19:30
@user14010: Does the command-linemysqlversion work? E.g.mysql -hlocalhost -uroot -p?
– Lekensteyn
Apr 10 '11 at 20:57
Yes it works. I am able to login to mysql through command line version but not with phpmyadmin. The reason why I am trying to use phpmyadmin is I have a sql script when I am trying to import it using the commandline mysql it is creating problems with the foreignkeys resulting in error 121. When I import the same script uing phpmyadmin it succesfully creates the tables
– user14010
Apr 10 '11 at 21:11
@user14010: What error message did you get? I've updated my answer with the location of the PMA configuration files.
– Lekensteyn
Apr 11 '11 at 12:50
add a comment |
By "rootuser" you mean the MySQL root user, not the system root user, right?
During the installation of mysql-server, the MySQL root account is created and its password is stored in /etc/mysql/debian.cnf.
The configuration files of phpMyAdmin are stored in /etc/phpmyadmin.
answered Apr 10 '11 at 19:01
LekensteynLekensteyn
121k48266356
By "rootuser" you mean the MySQL root user, not the system root user, right?
During the installation of mysql-server, the MySQL root account is created and its password is stored in /etc/mysql/debian.cnf.
The configuration files of phpMyAdmin are stored in /etc/phpmyadmin.
answered Apr 10 '11 at 19:01
LekensteynLekensteyn
121k48266356
edited Apr 11 '11 at 12:50
answered Apr 10 '11 at 19:01
LekensteynLekensteyn
121k48266356
answered Apr 10 '11 at 19:01
LekensteynLekensteyn
121k48266356
answered Apr 10 '11 at 19:01
LekensteynLekensteyn
121k48266356
121k48266356
Yes, I mean MySQL root user and not the system root user.I found the config file. Why is phpmyadmin not allowing to log me in with the mysql user login
– user14010
Apr 10 '11 at 19:30
@user14010: Does the command-linemysqlversion work? E.g.mysql -hlocalhost -uroot -p?
– Lekensteyn
Apr 10 '11 at 20:57
Yes it works. I am able to login to mysql through command line version but not with phpmyadmin. The reason why I am trying to use phpmyadmin is I have a sql script when I am trying to import it using the commandline mysql it is creating problems with the foreignkeys resulting in error 121. When I import the same script uing phpmyadmin it succesfully creates the tables
– user14010
Apr 10 '11 at 21:11
@user14010: What error message did you get? I've updated my answer with the location of the PMA configuration files.
– Lekensteyn
Apr 11 '11 at 12:50
add a comment |
Yes, I mean MySQL root user and not the system root user.I found the config file. Why is phpmyadmin not allowing to log me in with the mysql user login
– user14010
Apr 10 '11 at 19:30
@user14010: Does the command-linemysqlversion work? E.g.mysql -hlocalhost -uroot -p?
– Lekensteyn
Apr 10 '11 at 20:57
Yes it works. I am able to login to mysql through command line version but not with phpmyadmin. The reason why I am trying to use phpmyadmin is I have a sql script when I am trying to import it using the commandline mysql it is creating problems with the foreignkeys resulting in error 121. When I import the same script uing phpmyadmin it succesfully creates the tables
– user14010
Apr 10 '11 at 21:11
@user14010: What error message did you get? I've updated my answer with the location of the PMA configuration files.
– Lekensteyn
Apr 11 '11 at 12:50
Yes, I mean MySQL root user and not the system root user.I found the config file. Why is phpmyadmin not allowing to log me in with the mysql user login
– user14010
Apr 10 '11 at 19:30
Yes, I mean MySQL root user and not the system root user.I found the config file. Why is phpmyadmin not allowing to log me in with the mysql user login
– user14010
Apr 10 '11 at 19:30
@user14010: Does the command-line
mysql version work? E.g. mysql -hlocalhost -uroot -p ?– Lekensteyn
Apr 10 '11 at 20:57
@user14010: Does the command-line
mysql version work? E.g. mysql -hlocalhost -uroot -p ?– Lekensteyn
Apr 10 '11 at 20:57
Yes it works. I am able to login to mysql through command line version but not with phpmyadmin. The reason why I am trying to use phpmyadmin is I have a sql script when I am trying to import it using the commandline mysql it is creating problems with the foreignkeys resulting in error 121. When I import the same script uing phpmyadmin it succesfully creates the tables
– user14010
Apr 10 '11 at 21:11
Yes it works. I am able to login to mysql through command line version but not with phpmyadmin. The reason why I am trying to use phpmyadmin is I have a sql script when I am trying to import it using the commandline mysql it is creating problems with the foreignkeys resulting in error 121. When I import the same script uing phpmyadmin it succesfully creates the tables
– user14010
Apr 10 '11 at 21:11
@user14010: What error message did you get? I've updated my answer with the location of the PMA configuration files.
– Lekensteyn
Apr 11 '11 at 12:50
@user14010: What error message did you get? I've updated my answer with the location of the PMA configuration files.
– Lekensteyn
Apr 11 '11 at 12:50
add a comment |
I encountered a similar problem in Ubuntu 14.04 using MariaDB. Instead of trying to change everything I just created a new user.
mysql -u root -p
Entered the root password
Created a new user using the following command:
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'some_very_complex_password';
Granted all permissions to newuser:
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
You can then log on using newuser in phpMyadmin. I would strongly encourage you to only grant specific privileges to newuser instead of Carte Blanche privileges but it's your own funeral.
answered Mar 29 '16 at 14:06
Garikai DzomaGarikai Dzoma
666
add a comment |
I encountered a similar problem in Ubuntu 14.04 using MariaDB. Instead of trying to change everything I just created a new user.
mysql -u root -p
Entered the root password
Created a new user using the following command:
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'some_very_complex_password';
Granted all permissions to newuser:
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
You can then log on using newuser in phpMyadmin. I would strongly encourage you to only grant specific privileges to newuser instead of Carte Blanche privileges but it's your own funeral.
answered Mar 29 '16 at 14:06
Garikai DzomaGarikai Dzoma
666
add a comment |
I encountered a similar problem in Ubuntu 14.04 using MariaDB. Instead of trying to change everything I just created a new user.
mysql -u root -p
Entered the root password
Created a new user using the following command:
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'some_very_complex_password';
Granted all permissions to newuser:
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
You can then log on using newuser in phpMyadmin. I would strongly encourage you to only grant specific privileges to newuser instead of Carte Blanche privileges but it's your own funeral.
answered Mar 29 '16 at 14:06
Garikai DzomaGarikai Dzoma
666
I encountered a similar problem in Ubuntu 14.04 using MariaDB. Instead of trying to change everything I just created a new user.
mysql -u root -p
Entered the root password
Created a new user using the following command:
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'some_very_complex_password';
Granted all permissions to newuser:
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
You can then log on using newuser in phpMyadmin. I would strongly encourage you to only grant specific privileges to newuser instead of Carte Blanche privileges but it's your own funeral.
answered Mar 29 '16 at 14:06
Garikai DzomaGarikai Dzoma
666
answered Mar 29 '16 at 14:06
Garikai DzomaGarikai Dzoma
666
answered Mar 29 '16 at 14:06
Garikai DzomaGarikai Dzoma
666
answered Mar 29 '16 at 14:06
Garikai DzomaGarikai Dzoma
666
666
add a comment |
add a comment |
Might for some reason the AllowRoot option be set to False? See the documentation.
edited Jun 12 '18 at 21:04
bshea
42738
answered May 11 '11 at 19:08
loevborgloevborg
5,56211823
add a comment |
Might for some reason the AllowRoot option be set to False? See the documentation.
edited Jun 12 '18 at 21:04
bshea
42738
answered May 11 '11 at 19:08
loevborgloevborg
5,56211823
add a comment |
Might for some reason the AllowRoot option be set to False? See the documentation.
edited Jun 12 '18 at 21:04
bshea
42738
answered May 11 '11 at 19:08
loevborgloevborg
5,56211823
Might for some reason the AllowRoot option be set to False? See the documentation.
edited Jun 12 '18 at 21:04
bshea
42738
answered May 11 '11 at 19:08
loevborgloevborg
5,56211823
edited Jun 12 '18 at 21:04
bshea
42738
edited Jun 12 '18 at 21:04
bshea
42738
edited Jun 12 '18 at 21:04
bshea
42738
42738
answered May 11 '11 at 19:08
loevborgloevborg
5,56211823
answered May 11 '11 at 19:08
loevborgloevborg
5,56211823
answered May 11 '11 at 19:08
loevborgloevborg
5,56211823
5,56211823
add a comment |
add a comment |
I recently came across a very similar issue with Ubuntu 12.04. I just couldn't seem to login with root & no password. I set the AllowNoPassword setting to TRUE in the config. Later I found out that I was editing the wrong config.inc.php file to add the AllowNoPassword setting.
Edit:
/etc/phpmyadmin/config.inc.php
Not:
/usr/share/phpmyadmin/config.inc.php
I believe the first is the debian local config file, which will override the usr version.
answered May 31 '12 at 1:24
jjwdesignjjwdesign
270112
add a comment |
I recently came across a very similar issue with Ubuntu 12.04. I just couldn't seem to login with root & no password. I set the AllowNoPassword setting to TRUE in the config. Later I found out that I was editing the wrong config.inc.php file to add the AllowNoPassword setting.
Edit:
/etc/phpmyadmin/config.inc.php
Not:
/usr/share/phpmyadmin/config.inc.php
I believe the first is the debian local config file, which will override the usr version.
answered May 31 '12 at 1:24
jjwdesignjjwdesign
270112
add a comment |
I recently came across a very similar issue with Ubuntu 12.04. I just couldn't seem to login with root & no password. I set the AllowNoPassword setting to TRUE in the config. Later I found out that I was editing the wrong config.inc.php file to add the AllowNoPassword setting.
Edit:
/etc/phpmyadmin/config.inc.php
Not:
/usr/share/phpmyadmin/config.inc.php
I believe the first is the debian local config file, which will override the usr version.
answered May 31 '12 at 1:24
jjwdesignjjwdesign
270112
I recently came across a very similar issue with Ubuntu 12.04. I just couldn't seem to login with root & no password. I set the AllowNoPassword setting to TRUE in the config. Later I found out that I was editing the wrong config.inc.php file to add the AllowNoPassword setting.
Edit:
/etc/phpmyadmin/config.inc.php
Not:
/usr/share/phpmyadmin/config.inc.php
I believe the first is the debian local config file, which will override the usr version.
answered May 31 '12 at 1:24
jjwdesignjjwdesign
270112
answered May 31 '12 at 1:24
jjwdesignjjwdesign
270112
answered May 31 '12 at 1:24
jjwdesignjjwdesign
270112
answered May 31 '12 at 1:24
jjwdesignjjwdesign
270112
270112
add a comment |
add a comment |
I installed MySQL using synaptic manager. Didn't have to enter a root password.
The command:
mysqladmin -u root password NEWPASSWORD
worked. I was able to login into PhpMyAdmin immediately.
edited Feb 8 '16 at 23:06
incBrain
1,843919
answered Feb 8 '16 at 21:30
omariojaomarioja
1
add a comment |
I installed MySQL using synaptic manager. Didn't have to enter a root password.
The command:
mysqladmin -u root password NEWPASSWORD
worked. I was able to login into PhpMyAdmin immediately.
edited Feb 8 '16 at 23:06
incBrain
1,843919
answered Feb 8 '16 at 21:30
omariojaomarioja
1
add a comment |
I installed MySQL using synaptic manager. Didn't have to enter a root password.
The command:
mysqladmin -u root password NEWPASSWORD
worked. I was able to login into PhpMyAdmin immediately.
edited Feb 8 '16 at 23:06
incBrain
1,843919
answered Feb 8 '16 at 21:30
omariojaomarioja
1
I installed MySQL using synaptic manager. Didn't have to enter a root password.
The command:
mysqladmin -u root password NEWPASSWORD
worked. I was able to login into PhpMyAdmin immediately.
edited Feb 8 '16 at 23:06
incBrain
1,843919
answered Feb 8 '16 at 21:30
omariojaomarioja
1
edited Feb 8 '16 at 23:06
incBrain
1,843919
edited Feb 8 '16 at 23:06
incBrain
1,843919
edited Feb 8 '16 at 23:06
incBrain
1,843919
1,843919
answered Feb 8 '16 at 21:30
omariojaomarioja
1
answered Feb 8 '16 at 21:30
omariojaomarioja
1
answered Feb 8 '16 at 21:30
omariojaomarioja
1
1
add a comment |
add a comment |
To log in as root in phpmyadmin:
echo "UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket';FLUSH PRIVILEGES;" | mysql -u root -p
Found at the end of this tutorial
Worked for me :)
edited Sep 8 '18 at 5:19
Zanna
50.5k13133241
answered Sep 8 '18 at 4:55
RicRic
1
add a comment |
To log in as root in phpmyadmin:
echo "UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket';FLUSH PRIVILEGES;" | mysql -u root -p
Found at the end of this tutorial
Worked for me :)
edited Sep 8 '18 at 5:19
Zanna
50.5k13133241
answered Sep 8 '18 at 4:55
RicRic
1
add a comment |
To log in as root in phpmyadmin:
echo "UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket';FLUSH PRIVILEGES;" | mysql -u root -p
Found at the end of this tutorial
Worked for me :)
edited Sep 8 '18 at 5:19
Zanna
50.5k13133241
answered Sep 8 '18 at 4:55
RicRic
1
To log in as root in phpmyadmin:
echo "UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket';FLUSH PRIVILEGES;" | mysql -u root -p
Found at the end of this tutorial
Worked for me :)
edited Sep 8 '18 at 5:19
Zanna
50.5k13133241
answered Sep 8 '18 at 4:55
RicRic
1
edited Sep 8 '18 at 5:19
Zanna
50.5k13133241
edited Sep 8 '18 at 5:19
Zanna
50.5k13133241
edited Sep 8 '18 at 5:19
Zanna
50.5k13133241
50.5k13133241
answered Sep 8 '18 at 4:55
RicRic
1
answered Sep 8 '18 at 4:55
RicRic
1
answered Sep 8 '18 at 4:55
RicRic
1
1
add a comment |
add a comment |
Me too,
echo "UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket';FLUSH PRIVILEGES;" | mysql -u root -p
This is good
answered Jan 15 at 14:17
Florian BizetFlorian Bizet
1
New contributor
Florian Bizet is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Please do not repost the same answer as already given. Instead, upvote the ones you found helpfull (once you have enough reputation)
– Marc Vanhoomissen
Jan 15 at 15:27
add a comment |
Me too,
echo "UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket';FLUSH PRIVILEGES;" | mysql -u root -p
This is good
answered Jan 15 at 14:17
Florian BizetFlorian Bizet
1
New contributor
Florian Bizet is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Please do not repost the same answer as already given. Instead, upvote the ones you found helpfull (once you have enough reputation)
– Marc Vanhoomissen
Jan 15 at 15:27
add a comment |
Me too,
echo "UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket';FLUSH PRIVILEGES;" | mysql -u root -p
This is good
answered Jan 15 at 14:17
Florian BizetFlorian Bizet
1
New contributor
Florian Bizet is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Me too,
echo "UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket';FLUSH PRIVILEGES;" | mysql -u root -p
This is good
answered Jan 15 at 14:17
Florian BizetFlorian Bizet
1
New contributor
Florian Bizet is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered Jan 15 at 14:17
Florian BizetFlorian Bizet
1
New contributor
Florian Bizet is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered Jan 15 at 14:17
Florian BizetFlorian Bizet
1
answered Jan 15 at 14:17
Florian BizetFlorian Bizet
1
1
New contributor
Florian Bizet is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Florian Bizet is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Florian Bizet is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Please do not repost the same answer as already given. Instead, upvote the ones you found helpfull (once you have enough reputation)
– Marc Vanhoomissen
Jan 15 at 15:27
add a comment |
Please do not repost the same answer as already given. Instead, upvote the ones you found helpfull (once you have enough reputation)
– Marc Vanhoomissen
Jan 15 at 15:27
Please do not repost the same answer as already given. Instead, upvote the ones you found helpfull (once you have enough reputation)
– Marc Vanhoomissen
Jan 15 at 15:27
Please do not repost the same answer as already given. Instead, upvote the ones you found helpfull (once you have enough reputation)
– Marc Vanhoomissen
Jan 15 at 15:27
add a comment |
Thanks for contributing an answer to Ask Ubuntu!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f34409%2funable-to-login-to-phpmyadmin-with-the-root-user%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Did you ever find the answer to this problem? I'm having problems myself as well.
– chrisjlee
Oct 10 '11 at 2:03