2

how can i log in to MySQL

view full story
linux-howto

http://askubuntu.com – I am new to ubuntu and installed MySQL use a rpm file, and started it use sudo start mysql, when i try mysqladmin -u root password test I get mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! I checked the mysqld folder and there is nothing what can i do the next? Thanks for your answers (HowTos)

Songlist's picture
Submitted by Songlist on 11/18/2011 – Made popular on 11/18/2011

Stories similar to how can i log in to MySQL

Mysql fun! 3 years 44 weeks ago

I am trying to set my root password for my mysql database. After I enter /etc/init.d/mysqld start

Starting MySQL: [FAILED] [root@server server]# [root@server server]# mysqladmin -u root password 'mypassword' mysqladmin: connect to server at 'localhost' failed

I have installed MySQL server 5.5 on Ubuntu 12.04. I am trying to start MySQL server on a different sock file.

The IP address on my server recently was changed, and after the change, i performed a restart and when it came back online MySQL stopped working. I am running Debian 6.

I type mysql -u username -p and I get this message:

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

any idea what happened? How to fix it?

Hello.

Running 10.04 server and mysql 5.01.

I experimendted innobackup which made a one backup file of all databases.

Tested restoring the database by first stopping mysql service (stop mysql), extracting the backup to a new dir (/var/lib/data), modified the /etc/mysql/my.cnf to point there and to check the mysqld.sock to point to /var/run/mysqld/mysqld.sock .

Code: [client] port

mysqld fails on F16 41 weeks 6 days ago

I have installed mysql and phpmyadmin via, yum. I get the message

#2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) The server is not responding (or the local server's socket is not correctly configured).

The problem though, is with mysql itself.

# service mysqld start Redirecting to /bin/systemctl start mysqld.service Job failed.

have installed MySQL server 5.5 on Ubuntu 12.04. I am trying to start MySQL server on a different sock file. By default MySQL runs on /var/run/mysqld/mysqld.sock.

I am trying to run the same server on /var/run/mysqld/mysqld1.sock.

I have the following problem: I cant get etherpad running, when my firewall rules are active.

My firewall: http://pastebin.com/82APzKhi

telnet localhost 3306 gives connection timeout

ps aux | grep mysql:

root 15212 0.0 0.0 4112 712 ? S 13:54 0:00 /bin/sh /usr/bin/mysqld_safe mysql 15526 0.7 0.9 426056 75392 ?

My VPS had a hardware failure, and I was knocked out of service for the past 24 hours. Now that it's back up, MySQL refuses to work.

I have a standard MySQL Server running on Red hat 5.7. I have edited /etc/my.cnf to specify the bind address as my server's public IP address.