How Make Mysqld Listen To Only 2 IPs
I have an development/test server on a windows 2000 box running. AFAIK mysql needs 127.0.0.1 to connect to the localhost, if I use it on the db-server's machine. Usually I'd connect via LAN so I need mysqld listen on 2 IPs.
1) 127.0.0.1
2) 192.168.1.42 <-- LAN-IP
This box has a second LAN-Interface and a third which connects to ADSL.
Those 2 are to be considered realm of evel.
I just rather have mysql listening on localhost and one of the
LAN-interfaces. Is this possible at all ?
There is this parameter for mysqld : bind-address
It only works with 1 aeddress. Even when I put 2 such lines in my.cnf it
just takes the second value.
Do I have to let it listen on 0.0.0.0 and let mysqld sort the access
attemts with the grant tables ?
View Complete Forum Thread with Replies
Related Forum Messages:
Listen To Modifications
I'm using MySQL databases from version 3.23.15 and up. I would like to monitor changes on some tables. Triggers would do great but they aren't supported in the versions I'm running. How could I monitor changes to specific tables and columns. The same functionality should be ideally working on all versions I'm using.
View Replies !
Set MySQL To Listen From Other Computers
I have a problem connecting to MySQL server! The server is working on the other computer than my scrpit(my web page). The IP of MYSQL computer is 10.0.0.2. and port 3306! When i try to connect like this : $link=mysql_connect("10.0.0.2.", "user", "password"); $db ="database_name"; ... I get the folowing massage: Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '10.0.0.2' (10061) in D:InetpubwwwROOT....... The ip, username, password and database name are all correct! It is said, that it's possible, that the MySQL is set to work on localhost! If this is the problem, where to configure mySQL, to be able to connect from other computer?
View Replies !
Cannot Start Mysqld Service..Timed Out Starting Mysqld Daemon
I have a problem starting mysqld service it says "timed out starting mysqld daemon" when i start the service.. here is what my log files contain: This is what the mysql log file shows: 081021 17:14:21 mysqld ended 081021 17:16:06 mysqld started 081021 17:16:06 [Warning] Can't create test file /var/lib/mysql/station109.lower-test 081021 17:16:06 [ERROR] Can't start server : Bind on unix socket: Permission denied 081021 17:16:06 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 081021 17:16:06 [ERROR] Aborting This is what my /var/log/messages file contain: ....
View Replies !
WHY? Mysqld START ; Ps -ef |grep Mysqld > Shows 12 Processes !!
/sbin/service mysqld stop Shutting down MySQL..[ OK ] /sbin/service mysqld start Starting MySQL[ OK ] ps -ef |grep mysqld |wc 12 170 2838 If I do a ps -ef |grep mysqld it shows 12 process one is my own grep one is mysqld_safe but then there is 10 mysqld when I expect only one mysqld there is 9 too many !!! WHY? What controls to start more than one mysqld process? I have another host where a stop and start only shows 2 process mysqld and mysqld_safe - which is what I expect?
View Replies !
STOPPING Server From Pid File /var/run/mysqld/mysqld.pid
For some reason, mysql died last night at 4 am (best as I can tell). Now I can't start it...even if I restart the whole server. Here's what's in the log: 051006 12:26:30 mysqld started 051006 12:26:30 InnoDB: Started; log sequence number 0 43634 051006 12:26:30 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 13) 051006 12:26:30 [ERROR] Can't start server: can't create PID file: Permission denied This is running as root...and there IS no mysqld.pid file in /var/run/mysqld, either, so it doesn't seem like permissions are wrong. if I try to start from command line, I get this: [root@server mysql]# /usr/local/mysql/bin/safe_mysqld & [1] 3680 [root@server mysql]# Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 051006 12:29:28 mysqld ended
View Replies !
Mysqld Max
I am trying to make mysqld max so i can create innodb tables but I am getting the following error when i run mysqld No Variable Match for: -0 'innodb_buffer_pool_size = 40M' ../mysqld version 3.23.56 for pc-linux on i686 I am unable to figure out what to do. This shows that it reads the my.cnf file but how can I get rid off this error??. My computer have just 64MB ram. Do u think that less ram is causing this error.
View Replies !
Mysqld Don't Log
In /etc/my.cnf I put an entry under [mysqld] section for mysqld.log as following: log = /var/log/mysqld.log However, mysqld actually does not log anything. Can any one out here help me to make it working.
View Replies !
Mysqld-nt
I am trying to eliminate the password that is associated with the 'root'. When in start with mysqld-nt --skip-grant-tables, the cursor goes down to the next line, but never gets to a new prompt. When I do alt-cntl-del and look at the processes, it shows mysqld-nt is running, it just sits there and flashes.
View Replies !
Mysqld
This could be a silly question, but I have a web-based MySQL/PHP application that contains sensative data. Now, I realize that MySQL is most secure (over network transfer) using SSL, but would there be a reasonable tradeoff to consider not using SSL if the only host that is allowed to connect to it is the localhost? I.E> there would be no out/in network traffic, so wouldn't adding SSL only slow things down without gaining much (if anything at all)? So, basically the only thing that can connect is PHP on the same server?
View Replies !
Mysqld-max
I have a mysql server with a couple hundred-thousand entires that constantly maxes out our server at peak times to the point where the database locks up. It uses up 99.9% cpu and over a gig of memory on our Dual Core 64 Athlon 2 Gig DDR machine.
View Replies !
My.cnf And Mysqld
I just finished installing mysql on my box. but i don't have my.cnf file or mysqld anywhere. but i'm sure mysql is running already. Code:
View Replies !
Mysqld-nt.exe
I'm running a set of INSERT with SELECT in MySQL and I noticed wich that process "mysqld-nt.exe" grows more and more until the performance be so low wich it to be impracticable. I tried to create and close the connection which each INSERT executed but the process "mysqld-nt.exe" stay in the same status.
View Replies !
Make
i have downloaded the mysql tarball and tried installing in the /usr/local/src but ..... i am unable to install mysql as whenever i try to type the command make && make install it throws me the error: Make: *** No rule to make target "install" .stop kindly advise me how to proceed with the installation
View Replies !
Set Mysqld.log Size
I'm experiencing some problems due to big '/var/log/mysqld.log' size (199 Mbytes), and I'd like to know if there's any method to set this file's maximum size.
View Replies !
MySQLD Binary Log
We've been using MySQLD for a few years now quite happily. It's amazing how well it performs. However, I have a minor issue, and I'm not sure how to deal with it. I've scoured the manual, searched list archives, the web, etc., and am coming up empty. Somehow, the server is recording the Binary log in the data directory. Each of these log files takes up a gigabyte. This would be all well and good if we were using the server in as a master in a replication setup, but we are not. It WAS formerly acting as a master in a replication environment, but we've long since made it the only SQL server on our network. We've removed (commented) all the lines in my.cnf that deal with replication, and the log-bin is one of these lines. To clarify: the log-bin line in the my.cnf file IS commented with a hash-mark (#). The server has been restarted since this change, and "SHOW MASTER STATUS" returns an empty set of data (only showing the field names.) the SQL command RESET MASTER does nothing. It does not delete the hostname-bin.### files. the mysqld commandline parameters follow: /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/inferno.pid --skip-locking We're running version 3.23.41 for pc-linux-gnu on i686, running on SuSE Linux 7.1, kernel 2.4.18 #2 SMP on a Dual-Processor Pentium II 450MHz server.
View Replies !
Mysqld Got Signal 11
I run 2 servers in a master-slave configuration (both Solaris 5.8 [64 Bit] and mysql4.0.14). Mysql (only on master) crashes exactly every 15 Minutes with the following message: -----schnipp--------------- mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Code:
View Replies !
Mysqld Startup
I'm using ssh to administer a mysql server, version 3.23.49, which I just installed. The problem when starting mysqld: I type "mysqld" at the shell prompt and hit return, then I get the message "mysqld: ready for connections". But then it doesn't give me back the shell prompt. I can type stuff on the screen, but it doesn't do anything. I've tried Ctrl-C and Ctrl-Z, but that does nothing. Any ideas?
View Replies !
Mysqld Logs
I have a DATABASE server running MySQLD 3.23.58.Users vist and sign up their interest in my website.Now the problem is arising that when a user signs up first , they get emails of confirmation from my server.In addition to these emails , the customer also gets some annoyed e-mails from someone residing/depending totllay on @yahoo.com email-address maintaining the anonymity. I did try by sending only e-mails to some my own email address, whether someone is sniffering through my traffic, but I got no e-mail except the ones I had sent myself. After this I added some other email addresses in my DB server but I sent no email to them at all.This time all email addresses got those *annoying* e-mails also. I am really fed up with this issue, getting no clue how to come to know about this.
View Replies !
Mysqld Without LinuxThreads
does anyone know if it's possible to compile MySQL under Linux so that mysqld doesn't rely upon LinuxThreads, but makes direct call to fork() or clone() system calls instead? I'm looking for a way to avoid the exploitation of pthreads under Linux.
View Replies !
Can't Shutdown Mysqld
I installed mysql-4.1.7 on solaris 8. I can start it using mysqld_safe. But when I tried to shutdown using 'mysqladmin -p shutdown' and type in the root password, it gave: mysqladmin -p shutdown Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'oracle'@'localhost' (using password: YES)' I started mysqld_safe under Unix account "mysql", why it complains about 'oracle'?
View Replies !
Mysqld.sock (11)
I get the following error: PHP Warning: mysql_connect() Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11) The server setup is: Ubuntu, PHP 5.0, MySQL 4.0.24, and lighttpd This error seems to be appears when the load on the server increases. I've looked online and searched the devshed forums but still didn’t find a solution.
View Replies !
Mysqld-nt.exe On WinXp
I run a phpbb2 forum on a winxp pro pc (up to date) with msyql 5.0.18, apache 2.2.0 and php 5.1.2. Every once in a while (maybe once a month or so), mysql unexpectedly and spontaneously terminates. This usually happens when no one is at the server (i.e. when the server is doing nothing other than running phpbb2, apache, msyql and php). The apache logs reveal nothing suspicious. Anyone know why this might happen? And maybe more to the point, anyone have a suggestion about how I could rig my server to monitor whether mysql is running and automatically restart it if it's not (so that I don't run into the problem where my forum goes down because mysql terminates and I can't do anything about it till I get home to restart mysql)?
View Replies !
Mysqld Restarts Itself
One of my servers uptime is about 12 days... Last night I went to bed with everything running and ok. The next day around lunch time, I checked phpmyadmin and it seemed the database said "Uptime 10 hours" ?? And my memory (HEAP) rows were gone... Does mysqld restart itself after days of uptime? If so, how can i stop it ?
View Replies !
Normal Mysqld
I'm on a dedicated server that isn't live and I'm the only person that's on it. I haven't done much on the box, yet when I check my processes with top, I see 11 mysqld processes lying there each taken up about 12 megs of memory.
View Replies !
Number Of Mysqld
i want to limit the number of mysqld daemons running on my linux system. despite my best efforts to search/find the configuration option for this i haven't been able to find a single bit of info on this topic, including searching the configuration options for the my.cnf file. right now my server is running twelve copies of mysqld, and i only need 3 at the most. i'm sure this is possible, i just don't know how. can anyone help me?
View Replies !
/var/log/mysqld.log Not Written To
for some reason, the mysql error log is not being written to. If I stop mysqld, rm the mysqld.log, start mysqld, the mysqld.log get's created. However, it doesn't contain anything. It should at least have 'started...' and a few other lines indicating that mysqld was started sucesfully, no? Here is my my.cnf as it pertains to the logs: --log-error=/var/log/mysqld.log --log-slow-queries=/var/log/mysql.slow.log /var/log/mysql.log is chown mysql.mysql and chmod -rw-r- Has anyone else experienced this? Any suggestions?
View Replies !
Handle Use By Mysqld.exe
When I run MySQL, I notice that mysqld.exe uses > 40,000 handles (according to Windows Task Manager).Is this normal? what all these handles are used for?
View Replies !
CAn't Connect Through Mysqld-nt
Here is a summary; am working on win2k os, downloaded phptriad, mysql4.xx, php5.xxx and installed them all, now when i start apache i can connect to my server (i.e 127.0.0.1) now for mysql. i noticed in task manager that there is mysql-opt is working, now from phptriad i run mysqlnt -d but i still can't connect to mysql using mysql FrontEnd, reading around, i tried mysqld-nt --console it says that there is another mysqld running on 3306, so changed the port for the mysqld section in my.cnf to 1234, but still can't connect.
View Replies !
Why Mysqld Does Not Start?
By Downloading and extracting mysql-5.0.67-win32.zip I installed MySQL server 5.0.67 as a service in WindowsXP.I am not able to start the server type mysqld please help me on this.I am able to start mysqld-nt.When at the command prompt the command "mysql --verbose --help" produces output.What is meant by responding to the mysql command not mysqld?
View Replies !
Mysqld Stalls
I have two tables, a table of properties, and a table of locations (i.e., zipcodes). The following query takes so long I gave up waiting for it to complete: SELECT * FROM properties LEFT JOIN locations USING (locationcode, locationtype) WHERE acres < 500 ORDER BY (price / acres) ASC, 'price' ASC LIMIT 100 I'm running debian linux, and: mysql Ver 14.12 Distrib 5.0.13-rc, for pc-linux-gnu (i486) using readline 5.0 An EXAMINE of the above SELECT reveals: id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE properties ALL NULL NULL NULL NULL 16424 Using where; Using temporary; Using filesort 1 SIMPLE locations ALL NULL NULL NULL NULL 31294 During the query, the mysqld process is using 99% of the cpu. Mysqld continues to use %99 of cpu even when client is killed. I finally gave up waiting and kill -15 mysqld. After a few seconds it gracefully died, and I restarted it. The problem is 100% reproducible. Does anyone have any clues? Is my SELECT above got a major flaw that makes the server go swap happy? I have 512mb memory, I'd think that'd be'nuff.
View Replies !
Mysqld Is Not Running
cannot seem to run mysql commands, although queries seem to work well as I can make databases and view tables. Hope that makes sense. I installed mySQL 5 on Windows XP and tried to stick with the default installation options and paths. I lauch mySQL from this: ""C:Program FilesMySQLMySQL Server 5.0inmysqld", enter a password (but not a username so I'm assuming that's root user), get a mysql> prompt. So far so good. The following commands do not seem to work though: mysqladmin version mysqladmin variables Typing these commands then clicking the return key brings up the -> prompt. I've checked the processes and "mysql.exe" and "mysqld-nt.exe" are running. From a c: prompt I tried to install mysqld and was told it is already running. What am I missing here? I'm sure it is something very simple... Ultimately I need to bring in a table from a SQL dump from another system. I've tried using variations of: mysql -h host -u user -p dbname < dumpfile.sql I'm combing through the docs, but still don't have a clue.
View Replies !
Removing Mysqld-net.exe
Recently I removed MySQL 4.0.15 from my pc, but have noticed that a process called 'mysqld-nt.exe' is still running in the task manager. I have tried shutting down and uninstalling the service via the command line, but since the mysql directory no longer exists the system reports there is nothing to remove! Should I re-install mysql 4.0.15 and try un-installing it again, or does anyone know a quicker way to fix this problem?
View Replies !
Mysqld-nt: Multithreaded?
A server at work is running Windows and has a dual core Xeon processor. It is running MySQL (mysqld-nt.exe) but it never utilises more than 50% of the CPU (all of one core, obviously). Is there a way to have the process use both cores? I'm getting conflicting information around the web about whether or not it is even multi-threaded (v5.0) and it seems a shame to not be using the other core as it just sits idle all day otherwise.
View Replies !
Make This INSERT
table 1 productID int(10) auto_increment primerkey fk_type int(11) price double table 2 typeId int(11) Nej auto_increment primerkey name varchar(60) information text I wonder how do I write the insert question to insert values to the two tables
View Replies !
Make A Registration
I am trying to make a registration page for my site. I try to make a table called users, here is what I put in it: CREATE TABLE users ( usersID INT NOT NULL AUTO_INCREMENT , PRIMARY KEY (usersID) , firstname varchar (25) , username varchar (35) , password varchar (12) , email varchar (45) , gamertag varchar (21) , gender varchar (6) , ) ENGINE = MYISAM ; I get this error "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 ') ENGINE = MYISAM' at line 11" Do I have to download or set up something for the MYISAM Storage Engine to work or something?
View Replies !
Make A Loop
i got this table with different numbers, and i have to compare each of them to a value stored in a variable. when i get match, some statements run; however, i dont know how to get one value at a time! heres what the pseudo code looks like @fixedvalue=5 repeat if @fixedvalue = value i from rates then do some statements; i = i + 1; until @counter = count (*) from rates; do some more statements; i havent found the way to identify rows! thought triggers repeated on each row, but they dont, and indexes are not actually indexes as in 1,2,3....2700.
View Replies !
Make A Contact
How would I make a contact form that uses sql?Also, how would I make it so I could delete the submissions that are recorded by using a button on the .txt file they are sent to?
View Replies !
Make An Sql Backup
i have a phpmyadmin backup of an sql database but when I try to upload it now, I get errors because of the following reason: The insert quotes are with single quotes (by this I mean : ‘ ). The problem is this : if there is a ‘ in the insert query, it gives me an error. FOR EXAMPLE: Insert into(‘xxx’,’xxx’,’xxx’,’xxx’) Works fine, but when you have: Insert into(‘xxx’,’xxx’,’I’ll type some message here’,’xxx’) You get an error because of the ‘ in I’ll type Anyway to fix this problem?
View Replies !
Can't Make The Right SQL Statement - Please, Help
I am trying to pull out the data from teh server with the dvd's names that start from 0 or 2 (both numbers): SELECT * FROM dvd_product WHERE product_publish = 'Y' and product_parent_id = 0 and product_name like ƈ%' or like Ɔ%' and it DOES NOT WORK.. please, help me out it here.. thanks! P.S. basically i need to pull out all the dvd's, which titles start from NUMBERS..
View Replies !
Mysqld Logs Sniffering
I have a DATABASE server running MySQLD 3.23.58.Users vist and sign up their interest in my website.Now the problem is arising that when a user signs up first , they get emails of confirmation from my server.In addition to these emails , the customer also gets some annoyed e-mails from someone residing/depending totllay on @yahoo.com email-address maintaining the anonymity. I did try by sending only e-mails to some my own email address, whether someone is sniffering through my traffic, but I got no e-mail except the ones I had sent myself. After this I added some other email addresses in my DB server but I sent no email to them at all.This time all email addresses got those *annoying* e-mails also.
View Replies !
Backup :: Mysqld.exe Won't Run With Old Ibdata1
Yesterday my windows crashed. ok so i've copy'd the ibdata1 and my folder of the databasename(FRM files). so i've reinstalled mysql, Pasted those files into the data folder, But when i try to open my database it doesn't open. It says something like no connection mysql localhost. After a while i came up that mysql isn't running. But everytime i try to get it running with the old ibdata1 mysql won't start. if i just use the new one that is default made it can be opened. BUT without my data files of the databasename. That's because i can't open mysql with the old ibdata1 file mysqld.exe won't run. ERROR FILE: InnoDB: ########################################################## InnoDB: WARNING! InnoDB: The log sequence number in ibdata files is higher InnoDB: than the log sequence number in the ib_logfiles! Are you sure InnoDB: you are using the right ib_logfiles to start up the database? InnoDB: Log sequence number in ib_logfiles is 0 46409, log InnoDB: sequence numbers stamped to ibdata file headers are between InnoDB: 11 3988285905 and 11 3988285905. InnoDB: ########################################################## InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 081207 1:37:06 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 081207 1:37:07 InnoDB: Error: page 7 log sequence number 5 4256277064 InnoDB: is in the future! Current system log sequence number 0 46409. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See InnoDB: ( address blocked: See forum rules) InnoDB: for more information. 081207 1:37:07 InnoDB: Error: page 1 log sequence number 12 493694498 InnoDB: is in the future! Current system log sequence number 0 46409. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See InnoDB: ( address blocked: See forum rules) InnoDB: for more information. 081207 1:37:07 InnoDB: Error: page 3 log sequence number 4 3727903890....
View Replies !
Mysqld.sock Not Found
When I enter mysql -u root -p I get this error:PHP Code: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) I've searched google and there are hundreds of threads in other forums about this same question. All of them are unanswered that I looked through. I asked in a couple IRC rooms and noone seemed to know exactly what the problem could be. A lot of people were telling me that the socket is probably being created somewhere else but they didn't know how to find out where its being created or how to change it. I checked my.cnf and the sockets are all set to /var/run/mysqld/mysqld.sock. Does anyone know what the problem is or how to fix it?
View Replies !
|
TRACKER
