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.conf
[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
New contributor
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.conf
[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
New contributor
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.conf
[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
New contributor
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.conf
[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
New contributor
New contributor
New contributor
asked 3 hours ago
Richard BernsteinRichard Bernstein
1
1
New contributor
New contributor
add a comment |
add a comment |
0
active
oldest
votes
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
});
}
});
Richard Bernstein is a new contributor. Be nice, and check out our Code of Conduct.
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
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Richard Bernstein is a new contributor. Be nice, and check out our Code of Conduct.
Richard Bernstein is a new contributor. Be nice, and check out our Code of Conduct.
Richard Bernstein is a new contributor. Be nice, and check out our Code of Conduct.
Richard Bernstein is a new contributor. Be nice, and check out our Code of Conduct.
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