Xampp, MySQL Not Responding
Alright, so after struggling for about a week to get Apache, PHP, and MySQL working properly together, I gave up and installed Xampp.
It installed fine, and after some tweaking I was able to get to the phpMyAdmin login page, and it gives me this error:
#2013 - Lost connection to MySQL server during query
I was watching mysqld-nt.exe in my processes for a little bit, and noticed that it never changes... Never uses any CPU power, Memory Usage stays at 4,288 K... Is that normal? Even when processing queries?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
MYSQL Stops Responding
I've been running MySQL for about 3 months on a dedicated Win2003 server as a back in to a vbulletin forum with no problems. Over the last week I've had the database stop responding a couple of times. When I tried to cycle the service it would never stop. Now while I've been running MySQL for sometime I've not done much except make some tweaks to the config suggested on some forum I don't even remember. So I'm not expert, hence my post in the Newbie forum. So I have a somewhat busy forum, I guess, doing between 30000 and 40000 page views a day. Here are my details: Server OS: Windows 2003 Server Web Server: IIS6 PHP on web server: PHP 4.4.0 MySQL version: 4.1.14-nt Main database is about 500 Megs The first time it stopped responding was during the day during our busies time and the 2nd time was in the middle of the night during a backup. So now my question. I don't even know where to start to troubleshoot my problem.
MySQL Stops Responding
I am running a perl script which launches many processes simultaneously (using Parallel::ForkManager package), each fork gets data from a website and writes it to a MySQL database (there are usually 200+ simultaneous connections). It's very data intensive (I make roughly 3 million page requests per day). My problem is that after this program runs for a day or so, I am no longer able to write to the database. It basically locks itself! I cannot even properly shut it down (using mysqladmin -u root -p shutdown). I end up having to use "kill -9" as root user to shut it down and restart. The only thing I notice is that the table_locks_immediate is huge (around 4 million). I have set my max_connections to 800 and a "show status" usually has no more than 200 threads_connectes (as controlled by ForkManager).
Mysql Stops Responding
I am using mysql 3.*. I have several php scripts and java programs which access the mysql server. But from yesterday both my java and php programs keep on waiting for the mysql server. Everything worked well for about 2 days. All started yesterday. Mysql and my java and php programs are running on linux. Linux has glibc 2.2.*
MySQL Redhat Slow Responding To Connections
I have installed MySQL 3.53 on two RH7.3 and one RH9.0 boxes. On one of the 7.3 and the 9.0 box, when I try to connect remotely, it takes about 45 seconds to connect, whereas the other 7.3 box connects almost immediately. The fast box has standard install of 7.3 with tomcat added. The 9.0 box is straight RH9.0 standard install. I can't find anything in common between the slow boxes, but not on the fast one.
XAMPP / MySQL / Not Working
I installed XAMPP on my MAC Powerbook G4, running OS X 10.4. It all installed fine and I can see it in the applications menu. In there is also a script "mamppstart", when I click this I get the following message: Starting XAMPP for MacOS X 0.5... XAMPP: Starting Apache with SSL (and PHP4)... XAMPP: Starting MySQL... XAMPP: Starting ProFTPD... XAMPP for MacOS X started. I'm assuming that's good and means that everything has installed and running, however I try to locate MySQL in the Terminal and get nowhere. Also when I click my MySQL preference pane it says there is an error.
XAMPP Issues: MySQL
i am having trouble setting up my server. I have the latest XAMPP running on a windows98 machine. I have just installed it and I have to admit I am a total new-b at this but i managed to find the Apache configuration file and configure a few things like the listen port because my ISP blocks the default 80 for incoming, i configured the document root and also i saw this and did not know if it was important but i still configured it: # ServerName gives the name and port that the server uses to identify itself. # This can often be determined automatically, but we recommend you specify # it explicitly to prevent problems during startup. # # If your host doesn't have a registered DNS name, enter its IP address here. # ServerName XX.XX.XX.XX:PORT# ofcourse the X's being my IP address and port number at the end. So im wondering is this the name that you use to connect to MySQL ? if so with or without the port number? once again i am a total new-b to this, I have no idea. I am however currently reading "PHP and MySQL for Dummies", lol. and it has this test script i guess to check if MySQL is up and running: Code:
MySQL Doesn't Work In XAMPP
Ok i downloaded xampp, which has php,apache and mysql all in one, but mysql doesnt work... but ne way when i type my localhost i get the xampp screen which must mean that apache is working fine but what do i do now? im really confused between mysql and apache.
XAMPP MySQL Error Exporting To Csv (2)
For some reason I cannot answer the first tread with the same name, excluding (2). On all the other messages there is a Reply button ?!? The query is not the problem and maybe this isn't the right forum. The query runs fine in phpmyadmin. Only when I want to export the results to a csv file I get the errormessage.
XAMPP MySQL Error Exporting To Csv
When I try to export a query result to a csv file I get the following: (just a little piece af it). The last row beginning with <span class="syntax">< is very long and printed all on the same row. On one of the last rows is this message: #1305 - FUNCTION biljart.ROUND does not exist </code><br /> </div><fieldset class="tblFooters"> </fieldset> I don't use functions so the problem must be anywhere else (In XAMPP and php perhaps. Code:
Mysql Installed And Running But Wont Start (XAMPP)
hey iv installed xampp as i want to begin learning php and need the php and mysql servers, it all seems to be running fine in the control panel of XAMPP it shows apache and mysql as running. The problem is when i go to start mysql to create an actual database,by going: C:xamppmysqlinmysql the DOS window pops up and disapears and the motherboard beeps. Is this not the correct way of starting mysql for editing? im using wondows xp serivce pack2 and XAMMP 1.5.5.
Server Not Responding
i've installed php5, mysql 5.0.18 and phpmyadmin 2.8.1 i already config the config.inc.php,i set there the server localhost,root,and password. is there anything that i missed? when i browse the localhost/phpmyadmin there was a message welcome to phpmyadmin 2.8.1 but there was an error displaying MySQL said: #2003 - the server is not responding.
Database Stops Responding
I'm having a little problem where my mysql 4.0.21 for some reason stops "responding" until I do a flush-hosts. This is happening almost every day. It's a pretty heavy loaded server with at aprox 130 querys per second (it might not be that loaded for some of you :) ). I'm using the my-huge.cnf config, and allowing 350 max-connections. Code:
Error #2003 - The Server Is Not Responding
What is wrong? I just isnstalled MySQL Server 5.0, and when opening phpMyAdmin, it says: #2003 - The server is not responding And server IS running, so is PHP5, and Apache 2.0
Xampp Install
I installed MySQL through the Xampp install. My problem is administering the databases. I am using Ubuntu (like Debian) and installed the MySQL Administrator package that gives me a GUI admin prgram. Problems: 1) I can't connect to the localhost database in the GUI admin program 2) I don't know what my username is. - Xampp provides a web-based admin program that I have a user and password for. However I can't create a database in that program. Outside of that program it appears that my username is not a system user. Is there a way to log into mysqladmin with that username? 3) I can't admin the server other than adding tables to the premade databases.
XAMPP And MAMP Versions
I'm running an XAMPP version of mysql on a PC and the MAMP version on a Macintosh. I just realized that I needed to change a couple of tables. Can I change them on the MAMP version and then copy the appropriate files to the XAMPP version, and expect them to work? Which files should I copy over ... .MYI, .MYD or both? The MAC version is 5.0.19 The PC version is 5.0.27 I use Navicat to modify my tables on the mac and do not have this product for the pc.
Configuring XAMPP In The Domain
I am installing my XAMPP in my pc. It works fine. Everything works. My question is, is it possible to install XAMPP inside in my domain e.g., www.mydomain.com/xampp. Please help me to configure it using the domain, not in the localhost.
Xampp Install :Cannot Connect To Sql On Localhost 10061?
Please bear with me as i am totally new to php & sql. I am not sure if i did something wrong when i installed xampp but i am having trouble getting mysql to work. I have turned on sql in the xampp control panel. I am trying to acess sql via the following, Start Menu / Run / CMD CD "C:Program Filesxamppmysqlin" mysql I get the following message ERROR 2003 <HY000>: Cannot connect to sql on 'localhost' <10061> The command prompt stays as C:Program Filesxamppmysqlin> Am i supposed to set a user name or password?
ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (13)
I have a problem connecting to sql and can't find anything on the net to solve the problem. I have some sql databases running on a server. when I'm root on the server and I want to login to sql I do "mysql -ustudent -p -Dwordnet30 and it works fine. when I'm logged in with the user account on the server, i get this error message: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) so with the same user name in mysql, i can log on when i'm root, but not when i'm the user. the grant table for the user looks like this: Code:
Can't Connect To Local MySQL Server Through Socket '/home/data/mysql/mysql.sock' (13)
I just installed mysql on linux. If I open a terminal, su to root, then type "mysql", I am able to connect to the server and run my queries. If I exit out of su so that I am my own id (baisley) and type "mysql", I get this error: Can't connect to local MySQL server through socket '/home/data/mysql/mysql.sock' (13) Any idea why? mysql.sock has full permissions (read/write/execute), so it should be accessable by user baisley. If I am baisley and I run "mysql -u mysql" (as mysql is the user that the RPM set up), it will connect. What I would like to be able to do is run this without having to be user mysql all the time. How do I go about setting that up, or is it better to run all my queries/make tables as 1 user?
ERROR [HY000][MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL Server Has Gone Away
Hosting Package Environment: ASP.NET ver 2 MySQL 5.0 FP Extensions 2003 Progression: Developed Website Outline Developed Database in Access2003 Migrated AccessDB to MySQL @ Hosting Service using Migration Tool. Can connect using MySQL Admin tools and run queries fine and all data, relations etc. are there. PROBLEM: (The heart of the matter) Starting simple, created GridView Control using Microsoft Visual Web Developer 2005 Express, a few glitches here and there, used the MySQL Connector/ODBC v5.00.11 followed instructions. Can see database in Database Connections Window but when I try to connect the GridView Control to it I get: "Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and that the database is online. ERROR [HY000][MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL server has gone away" Had thought that "Microsoft Visual Web Developer 2005 Express" might be messing with the ODBC driver so thought to download the .NET Connector. That's when it all went bad. The documentation does not say how to install or use the connector or where to put the files. It seems to assume that these bits of information are common knowledge and I suppose that if I had kept up with the technology it might be. But alas I didn't and it Isn't and It Don't work.
Warning: Mysql_query(): Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I'm trying to connect to my MySQL database (sitehosted by GoDaddy) using PHP. I am having these errors and don't understand what they mean Warning: mysql_query(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Warning: mysql_query(): A link to the server could not be established in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Notice: Query: SELECT * FROM types MySQL error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 here4 Warning: mysql_close(): no MySQL-Link resource supplied in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 13 I've checked paths and connection settings and don't see any problems. My guess is now that the problem is coming from the opening and closing of the DB. my script, c_register.php uses a require_once('../mysql_connect.php') to open the connection to the database. But I also have a function definition in c_register.php that uses require_once('../mysql_connect.php') when called because it needs a connection to the DB. Here's a visual that might help:
MySQL Error Number 2003 :: Can't Connnect To MySQL Server On 'hostname'(10065)
I was running an older version of the query browser a while back to connect to an older version of mySQL (3.0) running on a linux box. The server hasn't changed, but the query browser has been upgraded to 1.1.10. I can't go back to the older version of the query browser because the machine that ran it got re-formatted so I downloaded the new version and installed it. So ... I get the following error when I try to connect: MySQL Error Number 2003 Can't connnect to MySQL server on 'hostname'(10065) Interestingly, I wrote a simple PHP script to connect to the server and pull some data off of it:
How To Configure MySQL ODBC Driver To Connect To A Mysql Server On My Own Side Of The Router?
Using MS Access, I have attached to MySQL servers in other states and other countries on the other side of my router. But when I use the MySQL ODBC driver 3.51 to connect to a MySQL server on my own LAN, the driver tells me it cannot make the connection. Here are the ODBC driver connection parms: Data Source Name: (free field - name my "my linux box" will do nicely) Host/Server Name (or IP) - something like MSQLUserName@ServerName.net has worked fine for me in the past. Now I'm trying 192.168.1.106 Database Name - whatever, mysqldb works fine, any valid db User - root Password - myrootpass Port - 3306 has worked fine 4 me N the past. Dunno whether 2 use now SQL Command On Connect - haven't ever put anything here Perhaps there is some configuration in mysql user privilege for the mysqluser "root" that would prevent him from logging from a remote PC to the mysql server?
Table Rows Inserted By Embeddded MySQL Cannot Be Retrieved By MySQL Tcp Client
I have encountered a weird behavoir of embedded MySQL. Through a simple program I made (in Delphi 6), I can insert rows to a table through embedded MySQL and I can retrieve the rows from my program. But using mysql.exe which points to the same table (through 127.0.0.1, with the same basedir and datadir), I cannot see the rows I inserted using my embedded program. Another way around, the rows inserted by mysql.exe can be seen in my embedded program. But after a row is inserted by mysql.exe, the rows inserted by the embedde program are deleted (or cannot be queried). Can anybody explain why is this? Is there a way to fix it?
I Want To Make Transfer Data Between MySQL Server To MySQL Local .
I want to make transfer data between MySQL Server to MySQL Local . My Environment. Server < --- > My PC Client Server = ::::: MySQL DB Server ( for Linux ) ::::: Apache .. ::::: Linux PC Client = ::::: Window ::::: MySQL run localhost ( for window ) How i transfer data from mysql server to mysql local .? Caz i don't want to connect via 3306 port .. Can i use others way?
Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I am using a Mac running Mac OS X 10.4.8 and I have successfully installed MySQL on it but when I go to run it using the command sudo ./bin/mysqld_safe & all it does is display a random dumber and when I try the command ./bin/mysqlshow -u root -p I get an error message saying Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Mac OS 10.3 -- Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock'
I just downloaded & installed MYSQL. It seemed to work and I can start it and enter my password and change a directory but that is about all. I have been ready and playing "hit & miss" all afternoon and it seems to have something to do with the "mysql_install_db" not being installed correctly -- I have tried multiple installs with multiple downloaws. My log. . .
MySQL Variables, Modifying Microsoft SQL Sequence Insert For Use In Mysql
I have the following microsoft SQL statement that inserts 25 new records in sequence. However I am trying to modify this to work in MySQL. I cant seem to get the variable decleration right. I tried using DECLARE CurVal int but that generates a mysql error. How can I modify the code below to work under mysql? Code:
Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock'
I've installed MySQL-4.0.14 under RedHat 8, using both rpm's and compiling from source. When I try to run MySQL, I get the following error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' After much searching on Google, and reading many newsgroup threads on this error, as well as reading the manual, I'm still stumped. Most of the advice I've found suggests that the path to mysql.sock is wrong, which makes sense, but I don't have the file mysql.sock anywhere on my machine, so obviously I can't correct the path.
Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I just got mysql 5, from mysql 3 or 4 (can't remember it's been so long). I can't seem to get a connection. I searched and found http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html#starting-server Here is what it says to do, I don't know enough to be able to follow. Please advise: If you have problems starting the server, here are some things to try: * Check the error log to see why the server does not start. ME: How? Where? * Specify any special options needed by the storage engines you are using. * Make sure that the server knows where to find the data directory. ME: How? * Make sure that the server can access the data directory. The ownership and permissions of the data directory and its contents must be set such that the server can read and modify them.
MySQL-error : Can't Connect To Local Mysql Server Through Socket
On a freshly installed Fedora C3 (incl. webserver apache php mysql) i get the following problem when connecting to mysql through a browser (phpMyAdmin):: #2002 Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock On the website of MySQL this error is mentioned but I found no solution. In /var/log/messages the following log occurs : localhost kernel: audit(....): avc: denied {write}for pid=2458 exe=/usr/sbin/httpd name=mysql.sock dev=hda13 ... What I have tried : - mysql.sock is srwxrwxrwx, seems ok, but dont know what the s stands for - the dir /var/lib/mysql was drwxr-xr-x and I changed it to drwxrwxrwx : no effect - tried different version of phpMyAdmin : same error - installed my website and got the following error : No connection possible with database (in the next version I will improve the error-messages) - through commandline there is no problem in connecting to mysql (log in, create databases, inserts, deletes, uploading dumps, making dumps, ....) What is the solution or what else can I try ?
Error With SQL Statement When Using MySQL 5.0.24 (Works Fine In MySQL 4.0)
Here is my query that worked in mySQL 4.0 but not in MySQL 5.0.24: INSERT INTO magtallynew SET magempnum=?', magcentre='YVRRC', entrydate=��-08-15', empnum=?', empcentre='YVRRC', connection='Rockwell', service='Express', region='dom', callertype='CSR', otherdept='', transferredcall='No', directrespdept='No', station='Not Applicable', withoutmagassist='Yes', category='Accounting', issue='Advised On Contact', comments='test' Here is the error message I get: #1064 - 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 'connection='Rockwell', service='Express', region='dom', callertype='CSR', otherd' at line 1
[MySQL][ODBC 3.51 Driver][mysqld-5.0.19-log]MySQL Server Has Gone Away
My site is hosted on Windows IIS, and I use ASP, and connect to MySQL 5.0.19 via an ODBC 3.51 driver. MySQL is I think hosted on a Linux machine. My problem is this: My site keeps getting lots of these errors messages each day: [MySQL][ODBC 3.51 Driver][mysqld-5.0.19-log]MySQL server has gone away I mean hundreds - e.g. for Feb alone, so far, these errors have been logged in my error table:
Remote Connection To MySQL DB Server From Client With No MySQL DB
I have MySQL server running on a Solaris machine. I have a Perl tool that is run on multiple operating systems (Linux, Solaris, MKS on windows, CYGWIN on windows). I would like to post to the MySQL database on the Solaris machine from this script when it is run on the different local clients. All these clients share a single network share (available via Samba on windows). Is there a Perl module that I can install in the network share that I can use to connect remotely to the server DB?
MySql: Select Database And Perform Mysql Dump
I currently have a batch file created using shell which runs mysqldump and saves the information to a file. However, I was wondering if there would be a way to use a recordset instead to select the database and initiate the mysql dump. Ideally this is what i would like to have: rs.Open "Use database mysqldump > C:", conn, 3, 3 Does anyone know if this is possible?
Mysql Can't Connect To Local MySQL Server Through Socket ...
does anybody know what exact problem mysql has when dieing by "mysql Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'" i encountered this problem when working on a huge xml file (~8megs) and it totally stunned my mysql server. myadmin throws the same error message now (#2002 - Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock') any ideas? maybe it's just an adjustment to the my.ini ...
Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mys
First of all, the mySQL server is running inside a Smoothwall firewall. I am using a DMZ Pinhole to port 3306 from a webserver with public internet access, to the mySQL Mandrake 10.1 linux box inside the firewall on the internal LAN. I am using mySQL v4.0.20 When I try to connect to the mySQL database, via HTTP only, from ANY other machine other than the mySQL server, I get the following error reported:- Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /var/www/html/cabstatus/connection.inc on line 7 Connect Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I am using a PHP script to access the mySQL database:- Code:
|
TRACKER
