Can't login into phpMyAdmin
I have been battling with this since 9AM and it is past 7:30 PM. My application was not able to communicate with mySQL. So I wanted to make sure I could get into it through phpMyAdmin. I can bring up the login screen(via localhost/phpmyadmin) in my browser, but It won't take my user and password. I've tried stopping it, running sudo mysqld --skip-grant-tables &
, and then starting it. No dice. when I type mysql
at the CLI I get
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
This makes sense since I don't have a /var/run/ directory.
I tried mysql -u richb201 -p
but I get
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Is there anyway for me to remove mysql and just reinstall it?
Here is my current mysqld.conf which is NOT in the /run/ directory
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
mysql phpmyadmin
add a comment |
I have been battling with this since 9AM and it is past 7:30 PM. My application was not able to communicate with mySQL. So I wanted to make sure I could get into it through phpMyAdmin. I can bring up the login screen(via localhost/phpmyadmin) in my browser, but It won't take my user and password. I've tried stopping it, running sudo mysqld --skip-grant-tables &
, and then starting it. No dice. when I type mysql
at the CLI I get
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
This makes sense since I don't have a /var/run/ directory.
I tried mysql -u richb201 -p
but I get
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Is there anyway for me to remove mysql and just reinstall it?
Here is my current mysqld.conf which is NOT in the /run/ directory
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
mysql phpmyadmin
add a comment |
I have been battling with this since 9AM and it is past 7:30 PM. My application was not able to communicate with mySQL. So I wanted to make sure I could get into it through phpMyAdmin. I can bring up the login screen(via localhost/phpmyadmin) in my browser, but It won't take my user and password. I've tried stopping it, running sudo mysqld --skip-grant-tables &
, and then starting it. No dice. when I type mysql
at the CLI I get
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
This makes sense since I don't have a /var/run/ directory.
I tried mysql -u richb201 -p
but I get
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Is there anyway for me to remove mysql and just reinstall it?
Here is my current mysqld.conf which is NOT in the /run/ directory
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
mysql phpmyadmin
I have been battling with this since 9AM and it is past 7:30 PM. My application was not able to communicate with mySQL. So I wanted to make sure I could get into it through phpMyAdmin. I can bring up the login screen(via localhost/phpmyadmin) in my browser, but It won't take my user and password. I've tried stopping it, running sudo mysqld --skip-grant-tables &
, and then starting it. No dice. when I type mysql
at the CLI I get
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
This makes sense since I don't have a /var/run/ directory.
I tried mysql -u richb201 -p
but I get
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Is there anyway for me to remove mysql and just reinstall it?
Here is my current mysqld.conf which is NOT in the /run/ directory
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
mysql phpmyadmin
mysql phpmyadmin
edited Feb 24 at 10:01
Thomas
3,87281527
3,87281527
asked Feb 24 at 0:27
Richard BernsteinRichard Bernstein
61
61
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Is there anyway for me to remove mysql and just reinstall it?
Yes there is:
sudo apt remove mysql-server
or
sudo apt purge mysql-server
The latter will ensure that all packages related to the installation are removed including configuration files.
Then to reinstall:
sudo apt install mysql-server
To set mysql root password run sudo mysql_secure_installation
command.
Thanks. when I run either remove or purge or install I get: Unable to locate package mysql. What to do?
– Richard Bernstein
Feb 24 at 12:33
Are you sure mysql is installed? What is the output ofsystemctl status mysql
? also trysudo apt purge mysql-server
. Also the firewall could be the issue.sudo ufw allow mysql
would resolve it.
– denmu
Feb 24 at 12:47
What is the output of systemctl status mysql? Unit mysql.service could not be found. I ran all of your suggestions. when I type $ mysql I get: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
– Richard Bernstein
Feb 24 at 12:51
Runsudo apt install mysql-server
– denmu
Feb 24 at 12:55
Ran it. Now when I type mysql I get : ERROR 1045 (28000): Access denied for user 'richb201'@'localhost' (using password: NO). Does that mean it is still there?
– Richard Bernstein
Feb 24 at 13:01
|
show 2 more comments
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%2f1120738%2fcant-login-into-phpmyadmin%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Is there anyway for me to remove mysql and just reinstall it?
Yes there is:
sudo apt remove mysql-server
or
sudo apt purge mysql-server
The latter will ensure that all packages related to the installation are removed including configuration files.
Then to reinstall:
sudo apt install mysql-server
To set mysql root password run sudo mysql_secure_installation
command.
Thanks. when I run either remove or purge or install I get: Unable to locate package mysql. What to do?
– Richard Bernstein
Feb 24 at 12:33
Are you sure mysql is installed? What is the output ofsystemctl status mysql
? also trysudo apt purge mysql-server
. Also the firewall could be the issue.sudo ufw allow mysql
would resolve it.
– denmu
Feb 24 at 12:47
What is the output of systemctl status mysql? Unit mysql.service could not be found. I ran all of your suggestions. when I type $ mysql I get: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
– Richard Bernstein
Feb 24 at 12:51
Runsudo apt install mysql-server
– denmu
Feb 24 at 12:55
Ran it. Now when I type mysql I get : ERROR 1045 (28000): Access denied for user 'richb201'@'localhost' (using password: NO). Does that mean it is still there?
– Richard Bernstein
Feb 24 at 13:01
|
show 2 more comments
Is there anyway for me to remove mysql and just reinstall it?
Yes there is:
sudo apt remove mysql-server
or
sudo apt purge mysql-server
The latter will ensure that all packages related to the installation are removed including configuration files.
Then to reinstall:
sudo apt install mysql-server
To set mysql root password run sudo mysql_secure_installation
command.
Thanks. when I run either remove or purge or install I get: Unable to locate package mysql. What to do?
– Richard Bernstein
Feb 24 at 12:33
Are you sure mysql is installed? What is the output ofsystemctl status mysql
? also trysudo apt purge mysql-server
. Also the firewall could be the issue.sudo ufw allow mysql
would resolve it.
– denmu
Feb 24 at 12:47
What is the output of systemctl status mysql? Unit mysql.service could not be found. I ran all of your suggestions. when I type $ mysql I get: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
– Richard Bernstein
Feb 24 at 12:51
Runsudo apt install mysql-server
– denmu
Feb 24 at 12:55
Ran it. Now when I type mysql I get : ERROR 1045 (28000): Access denied for user 'richb201'@'localhost' (using password: NO). Does that mean it is still there?
– Richard Bernstein
Feb 24 at 13:01
|
show 2 more comments
Is there anyway for me to remove mysql and just reinstall it?
Yes there is:
sudo apt remove mysql-server
or
sudo apt purge mysql-server
The latter will ensure that all packages related to the installation are removed including configuration files.
Then to reinstall:
sudo apt install mysql-server
To set mysql root password run sudo mysql_secure_installation
command.
Is there anyway for me to remove mysql and just reinstall it?
Yes there is:
sudo apt remove mysql-server
or
sudo apt purge mysql-server
The latter will ensure that all packages related to the installation are removed including configuration files.
Then to reinstall:
sudo apt install mysql-server
To set mysql root password run sudo mysql_secure_installation
command.
edited Feb 24 at 22:45
answered Feb 24 at 11:57
denmudenmu
214
214
Thanks. when I run either remove or purge or install I get: Unable to locate package mysql. What to do?
– Richard Bernstein
Feb 24 at 12:33
Are you sure mysql is installed? What is the output ofsystemctl status mysql
? also trysudo apt purge mysql-server
. Also the firewall could be the issue.sudo ufw allow mysql
would resolve it.
– denmu
Feb 24 at 12:47
What is the output of systemctl status mysql? Unit mysql.service could not be found. I ran all of your suggestions. when I type $ mysql I get: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
– Richard Bernstein
Feb 24 at 12:51
Runsudo apt install mysql-server
– denmu
Feb 24 at 12:55
Ran it. Now when I type mysql I get : ERROR 1045 (28000): Access denied for user 'richb201'@'localhost' (using password: NO). Does that mean it is still there?
– Richard Bernstein
Feb 24 at 13:01
|
show 2 more comments
Thanks. when I run either remove or purge or install I get: Unable to locate package mysql. What to do?
– Richard Bernstein
Feb 24 at 12:33
Are you sure mysql is installed? What is the output ofsystemctl status mysql
? also trysudo apt purge mysql-server
. Also the firewall could be the issue.sudo ufw allow mysql
would resolve it.
– denmu
Feb 24 at 12:47
What is the output of systemctl status mysql? Unit mysql.service could not be found. I ran all of your suggestions. when I type $ mysql I get: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
– Richard Bernstein
Feb 24 at 12:51
Runsudo apt install mysql-server
– denmu
Feb 24 at 12:55
Ran it. Now when I type mysql I get : ERROR 1045 (28000): Access denied for user 'richb201'@'localhost' (using password: NO). Does that mean it is still there?
– Richard Bernstein
Feb 24 at 13:01
Thanks. when I run either remove or purge or install I get: Unable to locate package mysql. What to do?
– Richard Bernstein
Feb 24 at 12:33
Thanks. when I run either remove or purge or install I get: Unable to locate package mysql. What to do?
– Richard Bernstein
Feb 24 at 12:33
Are you sure mysql is installed? What is the output of
systemctl status mysql
? also try sudo apt purge mysql-server
. Also the firewall could be the issue. sudo ufw allow mysql
would resolve it.– denmu
Feb 24 at 12:47
Are you sure mysql is installed? What is the output of
systemctl status mysql
? also try sudo apt purge mysql-server
. Also the firewall could be the issue. sudo ufw allow mysql
would resolve it.– denmu
Feb 24 at 12:47
What is the output of systemctl status mysql? Unit mysql.service could not be found. I ran all of your suggestions. when I type $ mysql I get: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
– Richard Bernstein
Feb 24 at 12:51
What is the output of systemctl status mysql? Unit mysql.service could not be found. I ran all of your suggestions. when I type $ mysql I get: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
– Richard Bernstein
Feb 24 at 12:51
Run
sudo apt install mysql-server
– denmu
Feb 24 at 12:55
Run
sudo apt install mysql-server
– denmu
Feb 24 at 12:55
Ran it. Now when I type mysql I get : ERROR 1045 (28000): Access denied for user 'richb201'@'localhost' (using password: NO). Does that mean it is still there?
– Richard Bernstein
Feb 24 at 13:01
Ran it. Now when I type mysql I get : ERROR 1045 (28000): Access denied for user 'richb201'@'localhost' (using password: NO). Does that mean it is still there?
– Richard Bernstein
Feb 24 at 13:01
|
show 2 more comments
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%2f1120738%2fcant-login-into-phpmyadmin%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