I installed Centos 5.3 with package standard of the MYSQL, configured this the same twirling in such a way localhost as in one it schemes with windows VISTA, to put I have others 4 you scheme with windows XP that I do not obtain to have access in the MYSQL. What I have to make pra these you scheme with XP to have access?
View 5 RepliesI need to connect a Server CentOS 5.6 with DB MySQL with a DB SQL Server 2008 on Windows Server 2008 R2 64bit, but i don't know how to do this.
So that MySQL DB has to import data from SQL Server on Windows Server.
i want connect ubuntu server to windows and retrive mysql from windows
View 8 Replies View RelatedI have two Centos 5 servers one running Asterisk with PHP installed and another sever running as a MySql Database server, at the moment when I try run simple script to see if I can connect to the remote server I get the following error.Quote:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
View 2 Replies View Relatedphp can't connect mysql by 'localhost' but can connect by IP address:
[Code]...
During the boot of CentOs I see this message which never stops scrolling during all the boot :
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
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 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'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:
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 centos installed in a VMWare . i have a windows server 2008 in a vmware too. i want connect centos (client) with windows (server), using dns in windows server. how to be this?
View 2 Replies View RelatedI 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'm trying to set up a VPN connection between our CentOS 5.3 server at work and my bosses XP computer at home. At this point, we are kinda locked into Quickbooks. I'm testing the connection from my XP boot at home to see if it works. I can log into our servicemanuals easily enough from XP at home however, the windows takes forever to update. I have the Samba server only listening on port 445 because is seems to work more efficiently at work. I connect to the Samba shares via linux from home and everything works well but, when I try to do anything with the shares from Windows client at home, it's very slow!
I'm thinking that it must have something either to do with the Windows OpenVPN client or the client.conf file. Is there anything I should look at in the .conf file for answers?
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]...
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 installed Fedora 12 with package standard of the MYSQL, configured this the same twirling in such a way localhost as in one it schemes with windows VISTA, to put I have others 4 you scheme with windows XP that I do not obtain to have access in the MYSQL. What I have to make pra these you scheme with XP to have access?
View 2 Replies View RelatedI am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
View 4 Replies View RelatedI 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
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)
I would like to connect to a separate mysql server, yet I can't find any documentation on how to do this.How would one achieve this? I am running qmail on centos4.
View 3 Replies View RelatedI cannot connect to mysql on my server.It is running but I cannot remember whether it has a password or not.I get this: [root myscripts]# mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)[root myscripts]#.I have tried running mysql -u root -h localhost -p and entering a blank password but no luck.
View 5 Replies View RelatedI've just decided to jump in and learn some PHP and MySQL stuff, by creating a dbase on our intranet server (CentOS5.4/Apache/PHP).
Everything seemed to go great with the MySQL dbase creation - I can even successfully connect to the dbase via ODBC on a Windows box (but there's no data in there yet).
My next step was to create a PHP form to gather info from intranet users, which would be submitted to and stored in the MySQL dbase.
I have tried following various basic tutorials online but I have started to struggle. If I run even the most simple of PHP connection on the server, I just get a blank page (i.e.: no 'connected' or 'failure to connect' message).
For instance:
<?php
mysql_connect("localhost", "admin", "1admin") or die(mysql_error());
echo "Connected to MySQL<br />";
?>
If I run this, I get a blank page.
How can I start to troubleshoot this? As mentioned I felt quite confident that MySQL was working due to success with ODBC, and the server already serves html/PHP services/pages as it's an existing intranet server.
How can I use SSH to connect to my mysql server remotely? SSH connects on port xxxx, so do I need to forward ports in the putty connection?
View 4 Replies View RelatedThis is my first post, I hope I'm the the right place. I installed mysql mysql-server php-mysql perl-DBD-mysql libdbi-dbd-mysql via "yum install -y" on a server running CentOS 5.3 X86_64 The install completes successful with no errors, but once I start mysqld via "chkconfig --level 35 mysqld on" ; "service mysqld start" There are no errors in /var/log/mysqld.log netstat shows mysqld listening on 3306 and localhost is in /etc/hosts
[Code]...
I have a fedora machine have apache server and from the .php on this page I am trying to connect to mysql database on another pc on my lan. But I get this error Failed to connect to server: Can't connect to MySQL server on '192.168.1.21' (13). What can be possible error? I dont know what else to search? I have php info page and can see the mysqli on this apache server?
View 9 Replies View RelatedI want to learn mysql ! i have a pc with no lan/wan connections (i mean no server-client relation) i installed mysql using synaptic , when it was installing mysql,it asked me for password (opened a window) then i typed in terminal
output is :
Running MYSQL 5.5.12 and MYSQL Workbench 1:5.2.34 on up-to-date Arch linux Set up MYSQL with root account and password. When running Workbench as user, got error when trying to connect :
Quote:
Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Can't connect to MySQL server on '127.0.0.1' (111)
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from
After commenting #skip-networking in my.cnf error changed to :
Quote:
Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Lost connection to MySQL server at 'reading initial communication packet', system error: 0
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from
Copying my.cnf to /etc/ and running Workbench as root didn't change anything, i still get the second error The wiki [URl] says to enable MYSQL in /etc/hosts.allow but i didn't do it, i guess it is required only when trying to access MYSQL from remote hosts which i dont.
I been going off old outdate guides and informaion around the internet and nothing is working
I have 2 Servers
Server A running apache, php, phpmyadmin
Sever B running MySQL
Server A has IP of 192.168.1.110
Server B has IP of 192.168.1.120
[Code]...
(This par was confusing to I just re-added the line above instead of searching for it all).
Then I set the MySQL vi /etc/mysql/my.cnf to comment out #bind-address = 127.0.0.1 There is another line that most of the guides asked me to comment out but I cannot find that like: # skip-networking
The Next closest match to that is: skip-external-locking
I will assume that is not it and leave it alone....
I keep getting errors for example: "Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly"
Another error was it canno connect because it is not accepting connections from the IP Address of my webserver..