Ubuntu :: How To Connect Mysql Serve

Apr 3, 2010

how to connect mysql server from ubuntu,.

View 3 Replies


ADVERTISEMENT

OpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock

Jun 7, 2011

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]...

View 6 Replies View Related

General :: Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (2)

Jun 2, 2010

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.

View 9 Replies View Related

Software :: Connecting To Mysql Database - Can't Connect To Local MySQL Server Through Socket

Aug 25, 2010

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:

View 4 Replies View Related

OpenSUSE :: MySQL Error 2002 (HY000): Can't Connect To Local MySQL?

Dec 6, 2010

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)

View 6 Replies View Related

Fedora :: MYSQL Error 2002 (HY000): Can't Connect To Local MySQL Server Through Socket?

Feb 22, 2011

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

View 7 Replies View Related

Ubuntu Installation :: Cannot Start Mysql - "Can't Connect To Local MySQL Server Through Socket:"?

Mar 15, 2010

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]....

View 1 Replies View Related

Programming :: Error ""Can't Connect To Local MySQL Server Through Socket" In Connecting To MySQL In C Language

Sep 29, 2010

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

View 3 Replies View Related

Networking :: Database Error: Unable To Connect To Database:The MySQL Adapter "mysql" Is Not Available

Jun 16, 2011

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]...

View 10 Replies View Related

Ubuntu :: Can't Connect To Mysql Through Terminal?

Aug 1, 2010

So, I've managed to install xampp on ubuntu and now I want access mysql through the ubuntu terminal. When I try with:

mysql -u root -p
I get:
the application can be found in the following packages

[code]....

View 5 Replies View Related

Ubuntu :: Connect To MySQL On System Using VB6 App?

Oct 26, 2010

I am looking for some advice on the best way to connect to a MySQL database on a Ubuntu server via SSH. The application is built using VB6 and is installed on a Windows server.

View 2 Replies View Related

Ubuntu :: 10.04: Can't Connect To MySQL Through Socket?

Dec 22, 2010

I am in the process of installing a genome brower on an ubuntu 10.04 (lucid). I achieved to see the browser once. Then, the mysql.sock disappeared and to solve this I tried first, to reboot the server with no results. Then I removed and reinstalled the MySQL server installing mysql-server-5.1. Now, I have a socket and MySQL is running (checked these out) but when I try to see the browser that is what I obtain:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

View 1 Replies View Related

Ubuntu :: Can't Connect PHP To MySQL In Kubuntu

Mar 9, 2011

I'm trying to run php scripts on Kubuntu 10.04 that connect to a MySQL database. These scripts run perfectly on OS X 10.6.6, but when I run them in Kubuntu, I get the following error: The script...

[Code]...

The error message: "Fatal error: Call to undefined function mysql_connect() in..." I've seen some posts in other boards about Red Hat problems like this, but nothing that can help with Kubuntu.

View 4 Replies View Related

Ubuntu Servers :: Can't Seem To Connect To Mysql

Jul 24, 2011

I'm using ubuntu 10.04 LTS I install mysql..Code: sudo apt-get install mysql-server.I set up my password and confirm,I type mysql at the terminal and i get this back.

View 1 Replies View Related

Ubuntu :: Installing LAMP -> Can't Connect To MySQl

Nov 10, 2010

im in the process of installing LAMP. im presently installing mysql and that's where i got into trouble...

im following the this tutorial [URL]

i tried the following :

Step 3. This is where things may start to get tricky. Begin by typing the following into Terminal:

mysql -u root

and i got this output:

root@konlah-laptop:/home/konlah# mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

obviously my question is why can't i connect to local mysql?

View 4 Replies View Related

Ubuntu Servers :: Can't Connect To Mysql Server From LAN

Nov 19, 2010

I've looked everywhere for this (simple) problem, and I can't get this working. I have a mysql server on my LAN which is accessible from within the server.I want to access the mysql server from another computer on the LAN, but it never works.

View 7 Replies View Related

Ubuntu Installation :: Cannot Connect To MySQL Db Through Drupal

Dec 24, 2010

i'm in the process of migrating from Drupal 5 to Drupal 6. My main Drupal page won't load. I have been stepping through the index.php Eclipse and XDebug.The error I'm receiving is:"can't connect to local MySQL server through socket '/tmp/mysql.sock'".i think the sock file setting is correct; it matches what the MSQL control panel has.

First question: if my.cnf says the sock file is in /var/run/mysqld, why do I keep getting the error that it can't open /tmp/mysql.sock? How do I tell Drupal to use '/var/run/mysqld/mysqld.sock'?
Second question: the mysql command-line interface (i.e., after i have logged into mysql from the terminal) doesn't mention a port from the listing obtained by entering 's'. is it possible that 3306 is a mistake? (I have tried commenting out the port reference and i still get the error identified at the top of the thread.)

does anyone have any ideas about how to resolve the 'sock' error? Many thanks if you do. Merry Christmas, too.

View 9 Replies View Related

Ubuntu Installation :: Connect Mysql With Tomcat?

Feb 16, 2011

But now I have task of connecting mysql and tomcat. I dont have any idea on this. However I looked some manuals but did not find any luck. how to connect mysql with tomcat. btw I have downloaded mysql connector and copied the .jar file to $CATALINA_HOME/lib

View 4 Replies View Related

Ubuntu Networking :: Can't Connect To MySQL On Server

Mar 8, 2011

My problem is that for some reason I can't connect to my MySQL on my server.I know it's not the script, other than the information that I'm using to connect.The MySQL server is set to "localhost" so I set the host in my php script to "localhost".I check for the username and they say I should try "root" so I set the username to "root".Then I put in my root password.When I go to where my php script actually starts, it gives me the error saying that I cannot connect. I know the rest of the script works and the error refers to the info I'm using to go in

View 9 Replies View Related

Ubuntu Servers :: Connect Mysql With Website?

Mar 15, 2011

I have a webhost payed and i want to connect it with my server database. It shows me this error on the website : Lost connection to MySQL server at 'reading initial communication packet', system error: 110

I tryed to open port 22...noone of sollution work to me.or someone who's good on that???

View 6 Replies View Related

Red Hat / Fedora :: MySQL Can't Connect From PHP (12)

Apr 26, 2010

We just set up a new Fedora 12 server. It can't connect from PHP....we're really stumped. Here's what we did to troubleshoot:Connected successfully (remote) from Workbench Connected successfully as the web site user from CLI Checked (and reinstalled) the php-mysql package Turned off iptables, no change installed mysql-devel packages We've got a drupal site installed and it does a function that checks if mysql_connect exists. Drupal says the function doesn't exist, so it's like PHP doesn't even see mysql. Now, we didn't uncomment the extension=mysql.so line in php.ini, but I checked my cPanel Cent machine and it wasn't uncommented there either, so I assume it doesn't have to be on Fedora/RHEL/Cent.

We installed from yum, we did NOT compile Apache/PHP/MySQL. We'd prefer not to if possible. UPDATE: We are running on a VPS and we had enabled mpm.worker (ie, we uncommented the worker line in /etc/sysconfig/httpd). Once we went back to using prefork, all is well. Apparently you have to compile php/apache to use worker.

View 1 Replies View Related

Server :: Cannot Connect To Mysql

Apr 5, 2011

I 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 Related

Server :: Can't Get PHP To Connect To MySQL

Feb 16, 2010

I'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.

View 3 Replies View Related

Ubuntu Servers :: Connect Throught Navicat MySQL Using SSH?

Jan 12, 2010

A few days ago, I ordered a ubuntu server (on ovh.com). Everything was going well until I installed mysql: After the install, I tried to connect throught Navicat MySQL using SSH, but it says that the user or password it's not correct, obviusly this is not true. I've been reading and I readed that I have to open the 22 port to use MySQL in the firewall, but I don't know how to do it.

View 3 Replies View Related

Ubuntu Networking :: Cannot Connect To MySQL (3306 Port)?

Jan 14, 2010

How do I get mysql 3306 port to be seen on my network?

Here is my setup:
---Desttop - WIndows Vista Ultimate (192.168.0.101)
--------VBox
------------Guest - Ubuntu 9.10 (Joomla CMS Development) (192.168.56.106)
---Server - Ubuntu 9.10 (192.168.0.100)
--------VBox
------------Guest - Ubuntu 9.10 (Joomla Production) (192.168.56.104)
------------Guest - Ubuntu 9.10 (MySql Database) (192.168.56.105)

I can ping all OS from any OS, I can connect to a shares, I can connect to the web server. I can do a netscan and display the open ports and the services for those ports except for MySql. How do get MySql to showup, so I can connect to it from my Joomla CMS? I came from openSuse and I like how they have modules to do this automatically. What do I use with Ubuntu to get the same results?

View 9 Replies View Related

Ubuntu Servers :: Mysql Cannot Connect To Exteranl IP Address

Jun 1, 2010

I am running a server with Ubuntu 10.04 and mysql v.5.4.41-3ubuntu12.1.I am unable to connect to my mysql server remotely, (error 111). I have added the port 3306 to iptables. It is able to connect to the loopback address (127.0.0.1) but not through its external address.

View 2 Replies View Related

Ubuntu :: Connect Open Office To Remote MySQL

Aug 3, 2010

I have several ecommerce websites and would like to be able to connect Open Office DIRECTLY to the site databases and do simple mail merging on envelopes. The problem is OO appears to be file based. I read a thread suggesting to remove the Ubuntu version of OO and install directly from their site. This is my problem:There's no wizard. The readmes included in their archive speak to a more experienced crowd. I THINK I'm just supposed to uninstall the existing one, then unzip the new OO to a folder? That doesn't sound right though because that does not load dependencies.

1. Is a re-install really the correct way to access remote MySQL databases?

2. Would upgrading to 10.04 give me the ability?

View 1 Replies View Related

General :: How To Connect To Mysql Database Using Php In Apache On Ubuntu?

Apr 21, 2010

how to connect to mysql database using php in Apache on Ubuntu?

View 4 Replies View Related

Fedora :: Can't Connect To MySQL Server

Apr 9, 2010

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 Related

General :: Can't Connect To Mysql Server ?

Aug 6, 2010

I 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 :

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved