I have mysql downloaded and when I type mysql into the command line I get this:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
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 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 have install mysql on my fedora12. My different mysql server is located in us. I want to check health status and hits per seconds everything. Is it possible with mysql-administrator command.
now a these days i am connect through ssh and excuting below command
#mytop mysql -u root -p <passwd>
In my mysql db i have added the userip & passwd (allowed the privileages for that ip)
If i use mysql-administrator i am getting below error
MySQL Error Nr. 2003
Can't connect to MySQL server on '66.98.152.64' (111)
My computer has broken and I cannot login. I don't know what caused it.
I am using Fedora 14 and so it is easy to retrieve my files with the Fedora 14 installation disk under the 'restore' option. I cannot however, work out how to retrieve my MySQL data.
Would anyone be able to shed some light on this matter?
I want to create database from script directly by taking inputs USER, PASSWORD and DBNAME.code...
How to resolve this or any alternate method (other than entering into mysql prompt like mysql -u USER -pPASSWORD)?
I am using ubuntu and mysql.I have a list of many .sql files, like 1.sql, 2.sql, 3.sql ... 100000.sqlI need to insert them into the database mysql mydb < *.sqlGives me: -bash: *.sql: ambiguous redirect
View 2 Replies View RelatedI 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'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 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]....
getting foll error during 'make' part of compilation of mysql v5.5.6rc
Code:
libtool: link: unsupported hardcode properties
libtool: link: See the libtool documentation for more information.
libtool: link: Fatal configuration error.
code....
I'm trying to install snort-2.8.5.3 on centos5-i386 an I get this error from ./configure --with-mysql --enable-dynamicplugin command:
ERROR: unable to find mysql headers (mysql.h)
checked in the following places
/usr
/usr/include
[Code].....
I've read here it has to do with libmysqlclient12-dev. How can I install libmysqlclient12-dev on centOS?
Is it possible to install snort from repositories using yum?
I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says
mysql-5.0.45-7.el5.i386 from base has depsolving problems
-- > mysql conflicts with mysql-server-community
error: mysql conflicts with mysql-server-community
i 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 just configured a complete Cent OS 5.2 system for use as a web server. I can configure Apache and PHP but MySQl seems to be causing some issues -
[mysqld]
datadir=/var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
[Code]...
Mysql starting problem after changing mysqladmin password.I tried all the solutions available on forums, but not solve the problem.At last I restored the mysql db backup, this make mysql service start, but till other databases not showing all tables.
View 1 Replies View RelatedI have the latest LAMP running on F10 but need to do a database conversion from mysql 4.1.22 to mysql 5 for a client.
View 4 Replies View RelatedIs it possible to carry out mysql commands directly from the ubuntu cli rather than open mysql?eg to create a database I would normally type
Code:
user@localhost:~$ mysql -u root -p
then INSIDE the mysql CLI I would type
[code]....
I wrote a code in C to connect to MySQL by using mysql_real_connect function but I recieved error "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" (by using mysql_error function).
I also did the following things: in mysql I typed 'SHOW VARIABLES LIKE '%SOCKET%'', it returned /var/lib/mysql/mysql.sock I typed 'mysql_config --socket' in shell, it returned /var/lib/mysql/mysql.sock I modified /etc/my.cnf file
Currently I'm using RHEL 5.3 in my server. Last time I install MySQl Server and it working fine.Then i facing a problem with my server and i reinstall back RHEL. But i didnt use MySql package inside the CD to install MySQL. i install MySQl separately. I download from MySql website. My problem is, i success install MySql in my server. The service also running. But when i type.
mysql -u root password
it said, command not found.
I've setup a CentOS apache web server, and loaded a site onto it. The site previously was functioning under windows xp (before I "stepped in") and wamp. What I did was copy the site in /var/www, reconfigure the httpd.conf (DocumentRoot /var/www/site, etc). Although when I try to open the webpage I get this error: Database Error: Unable to connect to the database:The MySQL adapter "mysql" is not available.
[code]...
I am facing some strange problem of mysql replication with ssl, my replications which working fine from more than 6 months currently stopped working after i upgrade mysql in to newver version mysql-5.1.41-2, i create new ssl self singed certs but still no sucess, when client try to connect the master using ssl its gives error SSL connection error ERROR 2026 (HY000), with out ssl its working f9.
Platform --> Fedora-11 + mysql-5.1.41-2 (both master/client)
I can seeking the problem on net, and i found the below bugzilla url related to that.
[url]
I read it but not get , either new version support x509 ssl certs or not or either new version support ssl replication or not, here below my server configuration for ssl serts
And for client
Both server and clients certs are signed with same ca but still its currently not working after the mysql upgrade first 5.1.41 and then 5.1.41-2
Either as above bugzilla url, currently mysql support ssl replication or not, or either some need to do special for working with ssl. or i wait for newver version of mysql to fix if its bug or not.
i ,musing mysql5 at fedora12 i have just installed it but i ,m using mysqladmin -p root password mypassword it says ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqladmin -uroot password 123456' at line 1
View 10 Replies View RelatedI 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).
I am trying to get mysql to start at boot without any success.
The mysqld scripts works fine when run from the command line, but it does not work when i use the links created by chkconfig. I checked the boot.log and found that mysql starts but then it stops or gets shutdown. This is the log message:
Starting mysqld daemon with databases from /data/mysql [ OK ]
Starting cups: [ OK ]
STOPPING server from pid file /var/run/mysqld/mysqld.pid
starting DenyHosts: /usr/bin/denyhosts.py --daemon --config=/usr/share/denyho
sts/denyhosts.cfg
090727 04:35:47 mysqld ended
The same init script works fine in Ubuntu.
I am installing MySql on Linux (Fedora core 11). Basically I am newbie & wana create a PHP application. I am done with PHP & Apache installation. I am facing some serious problems while Installing Mysql. below are all the tried codes & the outputs/errors:
[code]...
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code:
How do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies View RelatedPam-mysql can not connect to the database and below are my configurations.
saslfinger -s Output:
root@mailbackup:/# saslfinger -s
saslfinger - postfix Cyrus sasl configuration Tue May 10 10:12:10 EAT 2011
version: 1.0.2
mode: server-side SMTP AUTH
-- basics --
Postfix: 2.7.2
System: Slackware 13.1.0
-- smtpd is linked to --libsasl2.so.2 => /usr/local/lib/libsasl2.so.2 (0x00007f74ebfb7000)
-- active SMTP AUTH and TLS parameters for smtpd --
-- listing of /usr/lib64/sasl2 --
-- listing of /usr/local/lib/sasl2 --
-- content of /usr/lib64/sasl2/smtpd.conf --
-- content of /usr/local/lib/sasl2/smtpd.conf --
-- active services in /etc/postfix/master.cf --
-- mechanisms on localhost --
I have tried many different ways to interact with the mysql to reset the root mysql pass. This is what I got to right now
Code:
#!/bin/sh
newpass=$1
service mysqld stop
mysqld_safe --skip-grant-tables --skip-networking &
echo "use mysql;" >> /tmp/mysql_pass_reset.txt
echo "update user set password=PASSWORD("$newpass") where User="root";" >> /tmp/mysql_pass_reset.txt
[Code]...
