installed mysql
type
yum install mysql
tells me nothing to do - up to date
type mysql
responds ERROR 2002 - cant connect to local MYSQL server through socket
/var/lib/mysql/mysql.sock
Lost in tons of documentation - sun docs very general and maybe its there but I'm getting dizzy looking. How to get to the point where I can get an mysql> prompt?
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
I've downloaded and installed MySQL-client-5.1.53-1.glibc23.x86_64.rpm. I'm rather new to linux so it might be I haven't started the server. Unfortunately I have no idea which file is responsible for that. It is also possible that my head isn't functioning correctly ( if at all ).
Error I receive is:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.
Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.
Howver, just been trying to again to fix the problems with downgrading mysql and get:-
Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14
i installed mysql 5.1, the workbench and glassfish along with netbeans for an application I plan to build using the java EE. Glassfish is on local host 8080 and when I installed mysql after that, trying to start mysql from command prompt or even connecting through the workbench gives me error. for example going through the terminal and just typing mysql gives me: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) what should I do so both servers can run at the same time when deploying my application? on windows this is all handled for me. but apparently thats not the case on ubuntu
View 2 Replies View RelatedI need some help.Trying to set up bugzilla on my VM.After setting up the IP to use static i could log on to the url its not even loading up from command line its issueing an error.when i try to log on to mysql
bugzilla:~# mysql -u root mysql] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). I've had this problem to the point where I thought I messed up my actual configuration so bad that I reinstalled Ubuntu to get rid of all the MySQL configuration; I ran MySQL through Windows with a breeze, but I'm getting some errors like that after restarting my computer just a few minutes ago and I have not changed anything in my SQL settings. I'm on Ubuntu 10.10 64 bit and running MySQL 5.1. the actual error that I get from Navicat and from the website is at [URL]... Update: 20110402. Connection for controluser as defined in your configuration failed. Just got that when I tried to log in to phpmyadmin.
View 4 Replies View RelatedI have installed the mysql server on my ubuntu. I need to assign or reset the root password. I followed the article at http://www.ubuntugeek.com/reset-the-...-on-mysql.html. When I ran the command
[Code]....
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) what am i doing wrong, and explain to someone who almost has no experience with ubuntu. I am new to this.
Im getting this error when i try to run mysql from a shell
Code:
ERROR 2002 (HY0000): can't connect to local MySQL server through socket
I have installed MySQL over yum on fedora.
but the path and file /var/lib/mysql/mysql.sock does not exist on my system?
I've tried /etc/init.d/mysql start, and it actually starts, or at least, it doesn't error out. But when I do pgrep mysql I get nothing, and when I try to login with mysql -p as root, I get
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
None of my other logins work, either, but since pgrep mysql didn't work, it's clear that MySQL just isn't running. I tried uninstalling and reinstalling mysql-server via apt-get, but I get the same thing. The logs in /var/log/syslog show this:
Apr 11 14:31:26 /etc/init.d/mysql[9774]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Apr 11 14:31:26 /etc/init.d/mysql[9774]: error: 'Can't connect to local MySQL server
[code].....
I have an e-mail production server that has been running fine for almost two years.
Notice mail was not serving today and login to a bunch of errors in messages
However, I think they are all from not being able to access MySQL and when I:
mysql -u root -p
I get:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
how to upgrade from mysql5.1 to mysql5.5 version. Pls guide me in briefly.I did upgrade with the help of this url
http://www.ovaistariq.net/490/a-step...-to-mysql-5-5/ but i got error like this error:2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect FATAL ERROR: Upgrade failed
In /etc/my.cnf , i didnt get like this. Is this is the error
user = mysql; socket = /var/run/mysqld/mysqld.sock; port = 3306; basedir = /usr/local/mysql; datadir = /usr/local/mysql/data; tmpdir = /tmp; log_error = /var/log/mysql/error.log
I'm the lead Dev of GnackTrack and we're having issues with running MySQL on the LiveDVD.Once installed everything works fine, mysql can be connected to but when using the liveDVD we get the following error:
Code:
root@root:~# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Contents of /etc/mysql/my.cf point to /var/run/mysqld/mysqld.sock but because this is a liveDVD the actual file is located in:
/rofs/var/run/mysqld/mysqld.sock
[code].....
whenever i try to connect with phpmyadmin igot this error "#2002 Cannot log in to the MySQL server".how to recover this error?
View 6 Replies View RelatedI have fedora version 8 with mysql 5.0.45 installed. I have also installed drupal. Recently drupal gave me an error "error code 28". When i checked it out it seemed to be with the db. When i tried to created a db (for testing purposes) in root...i wasn't able to. so then i tried to restart mysql ...it stopped but unfortunately i have not been able to get mysql back up...i get a message saying
"Timeout error occurred trying to start MySql Daemon".
I installed MySQL 5 on Fedora Core 13 guest on Win Vista host. After I ran the bash script to install it:
Code:
groupadd mysql
useradd -g mysql
tar -xvf mysql-5.1.48.tar.gz
cd mysql-5.1.48
CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors
-fno-exceptions -fno-rtti"
./configure --prefix=/usr/local/mysql --with-mysql-ldflags=all-static --with-charset=utf8
make test
make
I ran the mysql but I received the error 2002 so I changed the my.cnf with medium.cnf, pointed in the file the path to the mysql.sock file and tried changing the owner of mysql.sock to the user mysql. It didn't work so in the end I gave 777 permissions (755 didn't work either). Now the error reporting when starting mysql is
Code:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111).
Running
openSUSE 11.3 (x86_64)
Linux 2.6.34.7-0.7-desktop x86_64
mysql-community-server_64 5.1.46-2.18-x86_64 from vendor openSUSE
php5-mysql 5.3.3-0.7.1-x86_64 from vendor openSUSE
Apache2 2.2.15-3.7-x86_64
apache2-mod_php5 5.3.3-0.7.1-x86_64 from vendor openSUSE
Trying to start mysql in YaST > system services (runlevel) >
Expert mode
gives following message
/etc/init.d/mysql start returned 1 (unspecified error):
for some reason, which I have exhausted all my thoughts upon..
I have mysql 5.0.77
I just made an amendment to the auto_increment_increment variable.. from 10 to 1
Gone to restart mysqld (im on redhat FYI) and get the error:
'Timeout error occurred trying to start MySQL Daemon.'
It fails to stop, and obviously fails to start.
I have included below my 'my.cnf' file but I cant see any issues with it, and can't for the life of me think why there is something wrong.
If I ever come across an issue, I don't tend to ask but instead try and figure it out (usually with success) but this time.. I just cannot get my head around it..
I am trying to set my root password for my mysql database. After I enter /etc/init.d/mysqld start
[code]...
Timeout error occurred trying to start MySQL Daemon. Then when I try to set the password for my root account I get
[code]...
I have a VPS running on centos-5-x86 and mysql server went down two days ago this is my mysql server log
110602 18:28:09 mysqld started
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110602 18:28:14 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
[Code]...
I thought that the problem is in the phpMyAdmin not in the mysql. But now i think different. It seems that the problem is right in the mysql. I think that there was no root user, when mysql was freshly installed. Unfortunately i did everything i can find on internet (some tutorials) but they don`t helped me at all, maybe i fu**ed up the mysql service. So i reinstalled it, and when i want to start it there is no file mysql.sock and i get the following:
linux-nepg:~ # service mysql restart
Restarting service MySQL
Shutting down service MySQL done
Starting service MySQL warning: /var/lib/mysql/mysql.sock didn't appear within 30 seconds
I installed MySQL and I want the service to (always) start. When I google I always find the same answer; Goto System > Administration > Services. But I don have it. Administration for me goes from 'Printing' to 'Software Sources', so there's no 'Services'...
Also should I be able to start it from a shell, but I also can find that. (I have no /etc/rc.d/-directory and my /etc/init.d/-directory han no 'mysql'). I just started using Linux a few days ago (I only used MaxOsX and Windows before).
I have a big database, which should "build up" before receiving requests, so i need httpd to start about 3 minutes after mysql start, so it prevents the visitors to start querys to the database, and making server load high. How can i do this.
View 10 Replies View RelatedI'm trying to start the mysql server on fedora 12. service mysqld start gives me an error:
MySQL Daemon failed to start.
Starting MySQL: [FAILED]
More details
[root@localhost mysql]# which mysql
/usr/bin/mysql
[root@localhost mysql]# mysql --version
mysql Ver 14.14 Distrib 5.1.46, for redhat-linux-gnu (x86_64) using readline 5.1
And also I get a weird pop in the notification area regarding some security threat
SELINUX is preventing /usr/libexec/mysqld "read" access on plugin.frm
i'm new to Debian os and currently want to install php5 apache2 and mysql 5.1. But ive got problem to start the mysql services.The error on command prompt as belows:
[Code]...
I have a mysql database and i use it with apache for my webpages. And I guess it dosen't start when the computer starts so I have to manually start it with "sudo /etc/init.d/mysql start" This returns fail so i went to '/var/run/mysqld/' and the folder was empty. I don't know if this is the problem or not. How can I fix this?
View 9 Replies View Relatedi am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
I am getting the following error when starting mysql using 'sudo /etc/init.d/mysql start':
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: ^G/usr/bin/mysqladmin: connect to
[code]....
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....