Specify Interface At Bind-address
Is it possible to bind MySQL 4.1 to more than 1 interface? Will
multiple 'bind-address=x.x.x.x' statements do the job?
View Complete Forum Thread with Replies
Related Forum Messages:
Does Bind Address Bug Fix?
In version 4.x has bug for bind-address. (http://bugs.mysql.com/bug.php?id=1200) Does this bug fix in 5.0 under windows 2000 envrionment? I try to remote access mysql server but failed. If I set bind-address=56.22.134.% under [mysqld] in my.ini file and start the server, it show the server stop. (I test under command line really fail to login.) If I remove the line of bin-address, and start mysql service. It show the server started. I double check the version of mysql is: c:> mysql -V mysql Ver 14.12 Distrib 5.0.15, for Win32 (ia32) c:>
View Replies !
Setting Bind-address
I know by default that the bind-address is set to 127.0.0.1 which is basically local host. What I'm wondering is if it is possible to set mysql to listen for connections from multiple specified IP's? The basic idea is that the main mysql database runs on a dedicated db server and other servers connect to the db via the specified port provided the proper permissions and so on. I've read that you can remove the bind-address line completely to make mysql listen for outside connections but that also opens up huge security holes. I'm sure there has to be a way to do what I'm looking for, I just haven't found it yet.
View Replies !
How To Make MySQL Bind To 2 Of 3 NIC's?
I have a system that has 3 NIC adapters, 1 is not on private network and I don't want MySQL to bind to that IP address. So, my question is how to accomplish this? I tried specifying multiple --bind-address= settings, but the last one overrides the first one and it only binds to one NIC.
View Replies !
Make MySQL Bind To 2 Of 3 NIC's
I have a system that has 3 NIC adapters, 1 is not on private network and I don't want MySQL to bind to that IP address. So, my question is how to accomplish this? I tried specifying multiple --bind-address= settings, but the last one overrides the first one and it only binds to one NIC.
View Replies !
Close Mysql Port Or Bind It To Only Localhost Or ...
I only use mysql locally. I want to - close port 3306 if possible (like starting Oracle database without starting listener), - or bind it to localhost only (like what sendmail does), - or next best thing for security. I am on redhat 9, and use mysql 3.23.55. I can upgrade if newer version provide the functionality.
View Replies !
Linux Mysql Nfs : Bind On Unix Socket: Function Not Implemented
I have installed Mysql on red hat ES release 3 and i was working great. For my applications, I decided to to put the data directory on another machine. The other machine is a big disk of storage (Adaptec snap server 1 terabyte) It working great for all applications except Mysql In fact, i put /var/lib/mysql on another machine and I made a nfs mount When i try to start mysql i have this : /etc/rc.d/init.d/mysqld start Timeout error occurred trying to start MySQL Daemon. Starting MySQL: [FAILED] in the error message i have this 051028 11:12:33 mysqld started 051028 11:12:33 Can't start server : Bind on unix socket: Function not implemented 051028 11:12:33 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 051028 11:12:33 Aborting 051028 11:12:33 /usr/libexec/mysqld: Shutdown Complete 051028 11:12:33 mysqld ended I have verified the permission and everything seems to be ok....
View Replies !
Can't Start Server : Bind On Unix Socket: Permission Denied
I have permission and owner ship for this folder set to user mysql and folder mysql-cluster is 777. Also, I am not running any other mysql server. Any help appreciated. Here is my error Quote: 070726 16:10:52 mysqld_safe Starting mysqld daemon with databases from /home/me/mysql/mysql-cluster /usr/local/mysql/libexec/mysqld: Table 'plugin' is read only 070726 16:10:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 070726 16:11:00 [Warning] NDB: server id set to zero will cause any other mysqld with bin log to log with wrong server id 070726 16:11:00 [Note] Starting MySQL Cluster Binlog Thread 070726 16:11:00 [ERROR] Can't start server : Bind on unix socket: Permission denied 070726 16:11:00 [ERROR] Do you already have another mysqld server running on socket: /home/me/mysql/mysql-cluster/mysql.sock ? 070726 16:11:00 [ERROR] Aborting 070726 16:11:01 [Note] Stopping Cluster Binlog 070726 16:11:01 [Note] Stopping Cluster Utility thread 070726 16:11:05 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
View Replies !
XA Interface
In 5.0 Manual,I see XA Interface( use SQL[XA START,...],Connector/J ). But, 1. I want know XA Interface in C API. ( using xa_switch_t like other DB ( oracle, infomix, .. ) )I can't find this in Manual. 2. If MySql is not support this, does Mysql have the plan?
View Replies !
XML Interface
Does anyone know of any project that would provide an XML interface to a database? I would like to create an XML document describing what I want to do, send it to a server and get some XML results back. Has anyone heard of anything like this?
View Replies !
Interface
MySQL is just the language that the database is programmed in, in a nutshell is that right? If so, it's not like Microsoft Access where you can create a user interface so the user can input data and apply queries to data etc. These are my assumptions, so my question is: Is there an open source application that applies a user interface to a MySQL database so a user can do these things?
View Replies !
Mysql GUI Interface
is there any GUI for mysql is availabe ??? just like SQL server or ms access .. not even like apart from phpmyadmin but like windows on which we can make database , tables , reocords .... etc .. i guess micro olap have this .. but its not free ..
View Replies !
Visual Interface
i tried the gui tools in mySQL.com but Im having some trouble instaling them, eventually ill be successful but I heard there are simpler packages, I just want to see the ER diagram of my databases, for the rest I can handle.
View Replies !
End User Interface
My goal is to set up a database to track our inspection data at our company. Currently, we are using Excel spreadsheets to make inspection reports. I would like to be able to get this information into a database so that a technician can set up the inspection plan before the inspector gets the part (the inspection plan would include the Customer Name, Part No., Revision, Items to inspect, etc.) Then when the inspector receives the part, they can pull up the inspection plan and enter the dimensional values obtained for each attribute on say six or ten parts and print an inspection report. Then this data can be sorted and viewed in different ways. We have three Windows 95 computers and three Windows 98 computers we are currently using on an ethernet network. I am thinking of using MySql, Apache and PHP to set this up. Would there be a simpler way to create an end user interface to MySql other than using PHP and Apache?
View Replies !
Mysql On Linux-gui Interface
Is there a GUI interface that is easy to install to manage MySQL on linux? I'm trying add a user account and password to the db server but I'm not having any luck from the command prompt.I'm trying to setup the nexus discussion software.
View Replies !
MS-Windows Front End Interface
Is there an MS-Windows front end interface for mySQL ? I'm thinking of an MS-Access sort of approach for basic database configuration and maintenance. Maybe there's a back door way to ODBC myself from MS-access to mysql on a Windows system ? Does Mysql have an ODBC front end I can get in through ? Any pointers to some directions ? I plan to use perl/my-sql for web work. But, it seems like a _lot_ of work to build the databases and populate them via mysql commands. I'd like to be able to work them _locally_ through a basic data maintenance program and then move it to the (web) server when ready.
View Replies !
Graphical Interface Hangs
In the older version of mysql, when I pressed browse, I could see the content of the table. If I ran a query, such as select * from table, it would scroll out the result. Now, with the newer version, all it does is hang. Is there some setting I'm missing that needs to be changed? This was newly installed on our apple server.
View Replies !
Local Interface To MySQL
I need to harvest data from MySQL tables. My experience is with MSSQL and Enterprise Manager. I also connect to MSSQL with Access and ODBC. I don't need to manage anything. I just need the data. What kind of interface can I use to query and save data locally? I don't see any MySQL drivers available when I try to setup an ODBC from my desktop. Can I download one somewhere?
View Replies !
MySQL Interface Required
I hope this question is appropriate for this group. My server provides a MySQL database. Do I need a third-party interface to add tables and records to it, or is their another way?
View Replies !
Interperted Language To Interface
my question is, what is the best interperted language to interface with MySQL? i was told Perl by some and Python by others. the reason i am looking is because i wanted to create a custom gui and atmysqlt to make it easy to add entries or pull up certain records from the database.
View Replies !
Microsoft Word Interface
I am developing an online app that helps many editors review articles, check for errors, add new articles, etc. The editors are used to using Word to help them go through several articles at once. Because of this, I'm hoping to figure out a way to allow several persons access to their content on a MySQL database online via their local install of MS Word. I have been working some with the OBDC mysql provides at http://www.mysql.com/products/connector/odbc/ (ver 3.51) and have been able to connect and retrieve some data. My problem is how do I update the users' articles online after they have finished reviewing them in MS Word?
View Replies !
MySQL C++ Interface Installation
After I downloaded MySQL C++ package & installed it, I can't compile any sources. System notes "undefine reference 'function' ", is anyone familar with gcc & MySQL C++ development package ?
View Replies !
Database And Client Interface
I am planning to use MySql for my building my database. I already installed MySQL on my system. I would like to know have two databases. 1. for developement 2. for storing the correct data from the development database. Can i have two databases on the same server, so that I can copy data from one database to another. Also, I am planning to interface matlab with MySQl. i.e., Matlab would be my client program. What drivers or connections do I need to download in order to talk to the database from Matlab.
View Replies !
User Interface With MySQL
is there product that provides a developable non-web user interface in the way that Access has one for its database? I've seen many that customize database routines, but what we want to do is create a user interface that includes logic without having to go through Php, Cfm, Net, or any of the web-based technologies.
View Replies !
GUI Interface Rennie Garcia
I have experience using other databases and wanted to find out if there is a high level GUI interface for MYSQL which enables me to create a database. I am using as a backend to a large PHP site and need any easier way of creating tables etc rather than using the command line editor.
View Replies !
Mysql Interface Generator
I wanted to know if there are any program that generates a webpage with the forms to insert data into the db. Example: I have a table with {id, url, desc} The program must generate a page with text fields to enter this information.
View Replies !
GUI Interface Book By DuBois
I have only read the book by DuBois and used samples at the command line. I would like to use this for work. I am avoiding the IT push to use Microsoft Access. I have 10 people in our group who need to share data (now about 50 excell spreadsheets). What I am really looking for is a GUI that can get me most of the way there. I can have my own server behind the firewall in our corporation so I am free to do my own thing. What I have found on the net so far is: Control Center Front SQLyog NAvicat Any feedback on these? Ease of use and reporting are most important attributes.
View Replies !
Export Table To .csv Via Web/PHP Interface
I have a website running Apache 1.3.31, PHP 4.3.0 and MySQL 3.23.45 (yes, I know...). Data from different tables is presented in lists on the webpage. I've been asked to add functionality to download lists as .csv-files. I have failed to find info about how to do this smoothly through a PHP script (not via command line).
View Replies !
GUI Interface For Unix Linux And Solaris Etc.
Is there a GUI Interface for MySQL ... that runs on Unix (Solaris, Linux, etc) There was an earlier thread about it - http://forums.devshed.com/showthread.php?t=51564&page=1&pp=15&highlight=GUI but most of these seem to run on Windows only.
View Replies !
Address Table
I have a table that contains addresses. I would like to end up with a record set where each record contains the two letter state code (which is how it is saved), and the sum of the rows in the table for each state. In other words, for each state, how many addresses?I could query each state individually and count the rows for each, but that seems a long way around
View Replies !
Host Address
is there a variable in mysql that stores the host address or ip of the remote machine issuing the command?I want records to contain the ip or hostname of the remote machines.i know how to do this in php, but i want this in pure mysql if possible.
View Replies !
Connection Address
I built my database in yahoo web hosting.But I couldn't fint the true address to create a connection between mysql database and my application?How can I find it ?
View Replies !
Address Table Set
I'm taking my Access Financial database and porting it over to MySQL, and I am building a web interface. The main purpose of this database is for me to store information on my purchases so I can run reports and stuff on it later. I decided to add a store information table to the database. I originally had the following information in one table for store information. storename suite number street city state zip country phonenumber rating comments I decided to break up the address into another table as I normally do, then I started reading about the 3NF and kind of talked myself into a logic problem. My plans now are to have seperate tables for Country City State Zip Address For Country, City, State, and Zip I will just do a FK between that and the store information table and use both the storepk and the other field as the PK of the table. A multi-multi linking design. For example storepk city Would be my table. My problem is I don't know how to handle the address part of the structure. I have the following fields I don't know how to put into a table suite number street I think I have 2 options with this piece of information, I can put it back into the store information table. Or I can put it into it's own separate table. If I put the address info into the store information then I will have multiple duplicate records as I have 8 Albertsons in the city I live in. If I put it into a separate table I don't know how to setup the PK. By setting up an Auto-Increment field I defeat the purpose of being dependent on a PK. My only other real option for data integrity is to make every field in the table part of the PK, and I'm not so sure that is a good idea. I can't really set it up by the storepk for example I have a dozen Chevrons in the city I live in, and if I got gas at a Chevron A all the time, then I would be okay. But if I ever got gas at Chevron B then I would have a duplicate record in the address table. Also I am unsure in the Address table if I should have a link back to the County, State, City, and Zip tables or not.
View Replies !
Graphical Interface Hangs When I Try To View Conents Of Table
In the older version of mysql, when I pressed browse, I could see the content of the table. If I ran a query, such as select * from table, it would scroll out the result. Now, with the newer version, all it does is hang. Is there some setting I'm missing that needs to be changed? This was newly installed on our apple server.
View Replies !
Efficient Storage Of IP Address
I am establishing a database for the purpose of logging access to my secure webserver and am wanting to make the database as efficient as I can because it will be doing a lot of work when the site goes live. What is the most efficient way in a MySQL table to store remote IP addresses? What data type should I use? Should I just go with a basic VARCHAR(15) to allow for 4 sets of 3 digits with 3 decimal separators, or is there a better way?
View Replies !
GROUP BY IP Address Range
I store IP addresses using the INET_ATON function, e.g. INSERT INTO myTable(IP_Address) Values (INET_ATON(123.123.33.12)); I would like to create a daily report that groups IP addresses by a "dotted triad", e.g. (pseudo SQL) SELECT myTable.IP_Address FROM myTable GROUP BY 123.123.33.*;
View Replies !
Calculate Total Ip Address
I have a database which is full of: ip address - uploaded - downloaded. What i am trying to do is find the totals for each ip address (repeats of the same ip gives the sum on the uploaded/downloaded) and then order the query by the ratio (total upload/total download). But im having difficulties constructing the query which will get the sums of uploads and downloads from the same ip and also order by the query without getting errors (divide by zero when total download is 0).
View Replies !
Replication :: Host Should Not Be An IP Address
the host should not be an IP address. I even checked the hostname of the machine and it is correct. I tried adding the correct host name to the username when connecting. Still get the same error. I even tried granting replication to 'repl'@'%' for all hosts and it still givess access denied to 'repl' @'10.68.0.1' tried granting replication to 'root'@'10.68.0.1' and it still gives me access denied. Tried grant all to 'repl'@'%' and 'repl'@'10.68.0.1' and it still gives me ACCESS DENIED. I did flush privileges after each grant statement.
View Replies !
User Address System
I'm working on a user based data system. I need to store a user's addresses which could be 0 or more. However the addresses could be domestic or foreign. I can tackle creating a multiple domestic address storage solution very easily. However, modifying this to encapsulate both a domestic and foriegn addressing system is boggling my mind. Mainly because foreign addresses don't all share the same format and ordering. Some use county, some don't. Some list a village, some don't, etc.... I'm looking for anything or anyone to provide me with some guidance and/or support to help development the foreign addressing system. I can modify it myself to integrate the domestic addresses.
View Replies !
Compare IP Address And Subnet?
I am trying to use mysql to do the following thing. I have tableA, in which all are single ips. sip ------- 1.2.3.4 8.8.8.8 123.3.32.1 .... and tableB, a list of our group subnets. subnet --------- 1.0.0.0/8 20.0.1.0/24 ..... What I want is only picking up those ips belong to our group from tableA according to the subnet tableB I can't figure out a way to compare ip and subnet, any ideas?
View Replies !
|
TRACKER
