Re: Connecting to mysql 4.1 server with a 4.0 client
Iain Conochie wrote: Afternoon, Apologies if this has been discussed before, I could not find a reference of it. So here we go :) Currently, I have a need to get a mysql 4.0 client to talk to a mysql 4.1 database. The error message I get is ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client Unfortunately, this is not possible. Is there any way of getting the server to use the 4.0 method of authentication? Cheers Hi - This will help: http://dev.mysql.com/doc/refman/4.1/en/old-client.html Unfortunately I've been in this position a few times, as well. Thanks -dant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting to mysql 4.1 server with a 4.0 client
Cheers Dan. Exactly what I needed :) Iain Dan Trainor wrote: Iain Conochie wrote: Afternoon, Apologies if this has been discussed before, I could not find a reference of it. So here we go :) Currently, I have a need to get a mysql 4.0 client to talk to a mysql 4.1 database. The error message I get is ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client Unfortunately, this is not possible. Is there any way of getting the server to use the 4.0 method of authentication? Cheers Hi - This will help: http://dev.mysql.com/doc/refman/4.1/en/old-client.html Unfortunately I've been in this position a few times, as well. Thanks -dant -- Iain Conochie UNIX System Administrator UK COLT Telecom Units 9-13 Powergate Business Centre, Volt Avenue, London NW10 6PW Tel: +44 (0) 20 7947 1286 Tel: +44 (0) 78 1514 5493 Email: [EMAIL PROTECTED] www.colt.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting to MySQL using C API
Have you tried my MySQL C API Site ? I have posted some C API examples here. http://www.geocities.com/jahan.geo Aftab Jahan Subear Subedar Technologies Subedar Baag Bibir Bagicha #1 North Jatrabari Dhaka 1204 Bangladesh http://www.DhakaStockExchangeGame.com Tel: +880-2-7519050 /* Get customized T-Shirts with logo for your IT company for 12 units @ US$14 ~ US$16. Order quantity must be atleast USD$5000++. IT company to IT company. */ premal mishra wrote: I'm using MySQL version 4.0.20a on win98. Compiler is Bloodshed Dev-C++ version 4. My program compiles and links but gives a page fault error on running. I'm linking the '\mysql\lib\opt\mysqlclient.lib' file. Linker gives the warning ignoring duplicate section '.text' CODE: #include config-win.h #include mysql.h #include stdio.h int main(int argc, char *argv[]) { MYSQL mysql; MYSQL *connection; connection= mysql_real_connect(mysql, localhost, root, premal, test, 0, NULL, 0); return 0; } Regards Premal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting to MySQL using C API
At 21:20 + 11/14/04, premal mishra wrote: I'm using MySQL version 4.0.20a on win98. Compiler is Bloodshed Dev-C++ version 4. My program compiles and links but gives a page fault error on running. I'm linking the '\mysql\lib\opt\mysqlclient.lib' file. Linker gives the warning ignoring duplicate section '.text' CODE: #include config-win.h #include mysql.h #include stdio.h int main(int argc, char *argv[]) { MYSQL mysql; MYSQL *connection; connection= mysql_real_connect(mysql, localhost, root, premal, test, 0, NULL, 0); return 0; } You forgot to initialize your MYSQL struct. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting 2 MySQL databases: how?
* Steijn, B.S. I would like to make a connection between 2 databases in MySQL that are on the same server. If you by connection mean to join tables from the two databases on the same server, you can do that. The purpose is that a class X in database A uses a class Y in database B by a foreign key. Thus, the table in B can be re-used by other databases which will make my databases more efficient. Right. I've already thought of a solution like FOREIGN KEY c_id REFERENCES A.customer(c_id)ON DELETE CASCADE but I think this will not work. Is there any other solution to do this? Right, this will not work. But this is a foreign key constraint, you don't need a constraint to make a join work. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Connecting to MySQL from ASP
See http://www.connectionstrings.com/ Regards, Ulises -Mensaje original- De: Ratmil Torres [mailto:[EMAIL PROTECTED] Enviado el: Miércoles 6 de Agosto de 2003 07:11 AM Para: [EMAIL PROTECTED] Asunto: Connecting to MySQL from ASP Hi. I am developing a web site using ASP. I need to connect to a MySQL Server. I am using ODBC, so how should the connection string be? I have already installed the ODBC driver for MySQL. Thanks.
RE: Connecting to MySQL from ASP
Depending on what driver of MySQL ODBC you are using. The one below I use for v3.51: strConnString = drver={MySQL ODBC 3.51 Driver};server=SERVER_IP;database=DB_NAME;user=UID;password=PWD;OPTION=4 The one below I used in the past for v2.50: strConnString = driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME Bill -Original Message- From: Ratmil Torres [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 8:11 AM To: [EMAIL PROTECTED] Subject: Connecting to MySQL from ASP Hi. I am developing a web site using ASP. I need to connect to a MySQL Server. I am using ODBC, so how should the connection string be? I have already installed the ODBC driver for MySQL. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting to mysql
Your 'root' password was probably not set hence, you didn't need a password. Bhavin. - Original Message - From: Pikasz Gyorgy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 17, 2002 7:46 AM Subject: Connecting to mysql I'm logged in to RedHat Linux as an user and I'd like to connect to mysql with mysql -uroot -p (and then must type the passw), but I could'nt in this way, only whit this: mysql -uroot, without passw. Why? picas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql server from other machines
See this thread : https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128 - Original Message - From: Michael Gargiullo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 04, 2002 9:26 AM Subject: connecting to mysql server from other machines I have a huge problem. I have several remote machines that connect to a mysql server. On Friday, the mysql server started returning ERROR 2013: Lost connection to MySQL server during query Any idea. Michael Gargiullo Network Administrator Warp Drive Networks 590 Valley Health Plaza Paramus NJ 07650 1-201-576-9292 x260 1-201-225-0007 - F www.warpdrive.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL on Linux from a Windows machine. -- Resolved !!
Well, after much fussing around with RPM's and searching this list, I have resolved my problem. The clue was the discussion on this list regarding the glibc bug. I upgraded to the 4.0.x RPM's that I got from the MySQL site and after I got all of the dependency problems fixed I was able to start up a MySQL/PHP setup that worked. Now both the website development works and I can use MyCC on the windows machine to administer the database. Thank you to all that considered my problem. --Will - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL on Linux from a Windows machine.
Will, Do you have a user/host pair for the client in the user table within the mysql database?? It's not good enough just to have a user, the host has to be setup too. I cannot connect from my Windows machine to the MySQL database running on the Linux server. I have tried several different programs and they all report an error that says Lost connection to MySQL server during connection. I have read all the articles I can find and searched the archives as well as I can figure out but I am still stumped. Here are some pertinent details. 1) The Server is running Redhat 7.3 and MySQL 3.23.49. It is on my local network at 192.168.3.2 and there are no firewalls between it and the Windows machine. (Both are behind the same firewall, and completely open to each other.) 2) The Windows machine is running Win98 SE at 192.168.3.x (DHCP). 3) On the linux machine I can access MySQL just fine. The mysql command works, and I can serve web pages with PHP/MySQL content. 4) I can telnet, Samba, xterm, etc. to the linux machine just fine. I can telnet to port 80 and get a connection although it doesn't do much there. 5) I cannot telnet to port 3306. When I try, I get an immediate Host connection lost. error. Any ideas would be most appreciated. Thanks, -- Will - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySQL on Linux from a Windows machine.
Hi, It seems to me that you can't connect to MySQL from an other machine at all. Did you start MySQL with the --skip-networking option? Try removing that option from the start-up scripts. \Olaf Will Merrell wrote: I cannot connect from my Windows machine to the MySQL database running on the Linux server. I have tried several different programs and they all report an error that says Lost connection to MySQL server during connection. I have read all the articles I can find and searched the archives as well as I can figure out but I am still stumped. Here are some pertinent details. 1) The Server is running Redhat 7.3 and MySQL 3.23.49. It is on my local network at 192.168.3.2 and there are no firewalls between it and the Windows machine. (Both are behind the same firewall, and completely open to each other.) 2) The Windows machine is running Win98 SE at 192.168.3.x (DHCP). 3) On the linux machine I can access MySQL just fine. The mysql command works, and I can serve web pages with PHP/MySQL content. 4) I can telnet, Samba, xterm, etc. to the linux machine just fine. I can telnet to port 80 and get a connection although it doesn't do much there. 5) I cannot telnet to port 3306. When I try, I get an immediate Host connection lost. error. Any ideas would be most appreciated. Thanks, -- Will - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- __XXX__ (0-0) +--ooO--(_)--Ooo---+ | | | Olaf van Zandwijk| | | | ICQ# 30231605| | PGP Public Key: http://www.vanzandwijk.net/pgp.txt | +--+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL on Linux from a Windows machine.
Thank you to both of you who responded to my question. I have checked both of these issues and found that neither solve my situation. 1) I have (and had) both a 'will@localhost' and a 'will@%' entry in the user table. Is there something else that has to be done to set up the host? 2) According to 'mysqladmin variables' the --skip-networking option is set to OFF. That should mean that Olaf's suggestion is satisfied, right? So I still need some more ideas. Why am I not able to connect to MySQL from another machine? Thanks, -- Will Randy Witt wrote: Will, Do you have a user/host pair for the client in the user table within the mysql database?? It's not good enough just to have a user, the host has to be setup too. And Olaf van Zandwijk wrote: Hi, It seems to me that you can't connect to MySQL from an other machine at all. Did you start MySQL with the --skip-networking option? Try removing that option from the start-up scripts. \Olaf In response to my Original Post: Will Merrell wrote: I cannot connect from my Windows machine to the MySQL database running on the Linux server. I have tried several different programs and they all report an error that says Lost connection to MySQL server during connection. I have read all the articles I can find and searched the archives as well as I can figure out but I am still stumped. Here are some pertinent details. 1) The Server is running Redhat 7.3 and MySQL 3.23.49. It is on my local network at 192.168.3.2 and there are no firewalls between it and the Windows machine. (Both are behind the same firewall, and completely open to each other.) 2) The Windows machine is running Win98 SE at 192.168.3.x (DHCP). 3) On the linux machine I can access MySQL just fine. The mysql command works, and I can serve web pages with PHP/MySQL content. 4) I can telnet, Samba, xterm, etc. to the linux machine just fine. I can telnet to port 80 and get a connection although it doesn't do much there. 5) I cannot telnet to port 3306. When I try, I get an immediate Host connection lost. error. Any ideas would be most appreciated. Thanks, -- Will - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL on Linux from a Windows machine.
Will, |||)So I still need some more ideas. I have to learn your problem each time again when I setup a new machine every half a year. I try each time the following hostnames: localhost (didn't work 4u) 127.0.0.1 (IP for localhost) hostname (e.g. databaseserver.mydomain.com- what you called the machine) 192.168.0.x (Your real network IP, can also be in 10.* or 172.25.*) localhost.localdomain (results to same as hostname) one of them fit's ;o) ... if not I install webmin from www.webmin.com and connect via Browser to the machine (http://IP.ADD.RE.SS:1 - login as root). In Webmin's server section you have a complete webbased MySQL administration. There I make all settings and forget about it. It just works after this setup. STIBS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL on Linux from a Windows machine.
Thank you, but at this point I am pretty sure that my problem is not a matter of entries in the user table. When I attempt to telnet into port 3306 the connection is immediately dropped. I don't really know if any connection is actually established at all, it may be established and immediately dropped on simply refused from the start. There does not appear to be any exchange of user names or passwords. I have several variations of my username and host name in the user table. I believe that one of them should have worked if that was the problem. I believe that the problem lies in the mysql configuration. I think that it is not responding to the TCP/IP port in the way that I need it to. I have verified that the --skip-network flag is NOT set (set to OFF) so it is not that simple, but I cannot find any other flag that looks any more promising. Any other Ideas? BTW Thanks for the webmin tip, I'll give it a try. Doesn't solve all of my problem, but it may help. Thanks, --Will -Original Message- From: STIBS [mailto:stibs-pi;gmx.de] Sent: Friday, October 18, 2002 1:35 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Connecting to MySQL on Linux from a Windows machine. Will, |||)So I still need some more ideas. I have to learn your problem each time again when I setup a new machine every half a year. I try each time the following hostnames: localhost (didn't work 4u) 127.0.0.1 (IP for localhost) hostname (e.g. databaseserver.mydomain.com- what you called the machine) 192.168.0.x (Your real network IP, can also be in 10.* or 172.25.*) localhost.localdomain (results to same as hostname) one of them fit's ;o) ... if not I install webmin from www.webmin.com and connect via Browser to the machine (http://IP.ADD.RE.SS:1 - login as root). In Webmin's server section you have a complete webbased MySQL administration. There I make all settings and forget about it. It just works after this setup. STIBS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL on Linux from a Windows machine.
Thank you, but at this point I am pretty sure that my problem is not a matter of entries in the user table. When I attempt to telnet into port 3306 the connection is immediately dropped. I don't really know if any connection is actually established at all, it may be established and immediately dropped on simply refused from the start. There does not appear to be any exchange of user names or passwords. I have several variations of my username and host name in the user table. I believe that one of them should have worked if that was the problem. If you try and telnet to port 3306 on the machine that MySQL is running on, you will see the connection being established, then you'll see garbage, as MySQL is designed to talk to clients on that port, not humans ;) If you are seeing the connection being established, then *immediately* dropped, not refused, then the problem may be in MySQL. If the connection is refused, this is a different issue. Depending on what version of MySQL and Linux/whatever you're running, I believe there's a verified problem with MySQL and RedHat Linux - mismatch of glibc version, I think. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql via ODBC from asp.net
dear jay fields, pls try this, hope this can help u... dim objconn, objrs set objconn = server.createobject(adodb.connection) set objrs = server.createobject(adodb.recordset) objconn.connectionstring=server=192.168.0.1;driver=MySQL;db=[database_name] ;uid=[user_name];pwd=[user_password] objconn.open connectionstring dim find_text, delete_text, mxopr_cd, deletelog_text mxopr_cd = session(oprcd) find_text = select * from tcity where tcity_code = ' cd ' order by tcity_code asc delete_text = delete from tcity where tcity_code = upper(' cd '); objrs.open find_text, objconn if objrs.eof then objrs.close objconn.close set objrs = nothing set objconn = nothing response.redirect /source/err/err_recnotexist.html else objrs.close objconn.execute delete_text objconn.close set objrs = nothing set objconn = nothing response.redirect /source/city/result_city_dele_ok.html end if cheers, Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com - Original Message - From: Jay Fields [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 27, 2002 21:35 Subject: connecting to mysql via ODBC from asp.net I've installed the windows version of mysql. I configured nothing. This is the code I'm trying to use to access mysql from an asp web service (in vb): - WebMethod() Public Function dbConnect() As String Dim connString As String = DRIVER={MySQL ODBC 3.51 Driver}; _ SERVER=localhost; _ DATABASE=test; _ UID=test; _ PASSWORD=test; _ OPTION=3 Dim MyConnection As New OdbcConnection(connString) Try MyConnection.Open() MyConnection.Close() Return connString Catch e As Exception Return e.Message End Try End Function -- It's returning the following exception: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql via ODBC from asp.net
ops, sorry jay, i forgot this... do you install mysql in your web server? if you install it on your web server, so i think you should install the odbc driver for mysql in your web server... and after that u can use your asp script to make connection to your mysql database have a nice try :-) Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com - Original Message - From: Jay Fields [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 27, 2002 21:35 Subject: connecting to mysql via ODBC from asp.net I've installed the windows version of mysql. I configured nothing. This is the code I'm trying to use to access mysql from an asp web service (in vb): - WebMethod() Public Function dbConnect() As String Dim connString As String = DRIVER={MySQL ODBC 3.51 Driver}; _ SERVER=localhost; _ DATABASE=test; _ UID=test; _ PASSWORD=test; _ OPTION=3 Dim MyConnection As New OdbcConnection(connString) Try MyConnection.Open() MyConnection.Close() Return connString Catch e As Exception Return e.Message End Try End Function -- It's returning the following exception: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySQL using OLEDB
Tell me what you do ADODB - OLEDB driver for ODBC - MyODBC - MySQL ADODB - MyOLEDB - MySQL or anything else? first case: check don't promt on connect Did you create a data source? (First thing you don't need to do...) But whatever you do with VB, MS ADODB and MySQL - you will need time. (Many time ;-) ) Chris - Original Message - From: Darrell A. Sullivan, II [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 31, 2002 9:04 PM Subject: Connecting to MySQL using OLEDB Can anyone tell me if it is possible to connect to a MySQL server running on Linux from a Windows Visual Basic application without setting up a DSN on the Windows computer? I know this can be done with MS SQL Server and I have heard it can be done with Oracle so I am wondering if there is a connection string that will work with MySQL. Currently everything I try brings up a DSN setup screen and this is something that I definitely do not want. Thanks for any help. Darrell - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to mysql Server
On Mon, 25 Feb 2002, Oladejo, Tokunboh wrote: Does anyone have an idea why I am getting an error Fatal error: Call to undefined function: mysql_connect() in /var/www That's the error you get if you try to call mysql_connect() but don't have the MySQL support compiled in to the PHP module. Rebuild the module, making sure that you have the MySQL support enabled. Watch the output from the configure stage, and see the PHP installation docs for more info. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to mysql Server
Thanx all, I am new to this and still learning, when I installed Linux, I did not have to do anything to PHP however I did just get the mysql rpm and install without any special configuration, Does anyone have an idea of any article that will help me recompile my php with my apache. Thanx - Original Message - From: Jeremy 'Circ' Charles [EMAIL PROTECTED] To: Oladejo, Tokunboh [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, February 25, 2002 3:21 PM Subject: Re: Connecting to mysql Server On Mon, 25 Feb 2002, Oladejo, Tokunboh wrote: Does anyone have an idea why I am getting an error Fatal error: Call to undefined function: mysql_connect() in /var/www That's the error you get if you try to call mysql_connect() but don't have the MySQL support compiled in to the PHP module. Rebuild the module, making sure that you have the MySQL support enabled. Watch the output from the configure stage, and see the PHP installation docs for more info. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySql
On Mon, 7 Jan 2002 00:03:20 +0100, Tue Hellstern wrote: I cant connect to a MySql Database form a Windows PC, I get Host ... is not allowed to connect to this MySQL server and in the MySql manual I found the following solution but I dont know how to do it. I am an novice in MySql. If anyone can make tell me the commands I will be very happy. In order to correct this problem, you or an administrator must be able to log into mysql as root. Then it is only necessary to issue a GRANT PRIVILEGES query such as: GRANT ALL PRIVILEGES ON *.* TO tue@% IDENTIFIED BY 'apassword' WITH GRANT OPTION; The above would permit user tue to log in from any location (%) with all privileges including the ability to grant privileges to others. Regards, Doug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySql
GRANT ALL PRIVILEGES ON *.* TO tue@% IDENTIFIED BY 'apassword' WITH GRANT OPTION; Ah but that doesn't work this is what worries me because I have a book on mysql that uses syntax like this and it generates an error on my system. This is a Red Hat 7.2 system, stock with Red Hat distributed upgrades. For example: [root@crab root]# uname -a Linux crab.ocean.yonderway.com 2.4.9-13 #1 Tue Oct 30 19:32:27 EST 2001 i686 unknown [root@crab root]# rpm -q mysql mysql-3.23.41-1 [root@crab root]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 55 to server version: 3.23.41 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql grant all privileges on *.* to foo@% identified by 'foobar' with grant option; ERROR 1064: You have an error in your SQL syntax near '% identified by 'foobar' with grant option' at line 1 mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySql
Put double quotes around % so that foo@% On Sun, 6 Jan 2002 18:31:00 -0500, Christian J Hedemark wrote: mysql grant all privileges on *.* to foo@% identified by 'foobar' with grant option; ERROR 1064: You have an error in your SQL syntax near '% identified by 'foobar' with grant option' at line 1 mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySQL from Oracle using MyODBC driver
it wuld be nice if mysql supported sub queries ie. select A.MESSAGEID from MESSAGEDATA as A where A.MESSAGEID in (select B.MESSAGEID from MESSAGES as B where B.SUBJECT='Invitation to join the hanky panky group') _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql from different computer
I suspect that you need to add an entry at the MySQL host for the machine that you are connecting from. This can be done with a GRANT statement: - Format: grant all privileges on databaseName.tableName to 'userName'@'hostName' identified by 'somePassword'; - Example: grant all privileges on myDB.* to 'clyde'@'coolPlace.org' identified by 'secretPass'; Then you'll need to reload the access privileges. It can be done at the command line like this: % mysqladmin -u rootUserName reload Remember, you may need to add the -p switch and suply a password for this command. Is this enough info? One more important question, if these privileges are now granted, will it then be possible for me to connect from MySQL client at the local machine to MySQL server at the remote machine? More so will i need to open MySQL server on my local machine before running MySQL client to connect to the remote machine e.g. c:mysql\bin\mysqld c:mysql\bin mysql -h coolPlace.org -u clyde -psecretPass Or I will just run the MySQL client to connect to remote machine without neccessarily running MySQL server at the local machine c:mysql\bin mysql -h coolPlace.org -u clyde -psecretPass Thanks for giving me relieve. -kamal. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql from different computer
[EMAIL PROTECTED] writes: More so will i need to open MySQL server on my local machine before running MySQL client to connect to the remote machine e.g. A client is a client and a server is a server. The point of separating the two is that you can then run the client somewhere and and the server elsewhere. So no, you do not need to have mysqld running locally to connect to a remote server. An decent analogy would be that you do not need to have a web server running to surf the web. I'd recommend you not to run anything that you do not need. Each additional server or daemon is a potential security hole. This is certainly true for mysqld, where the default privileges are very permissive. //C - pissed off at procter gamble for screwing up his shampoo. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql from different computer
Good morning Kamal, From: [EMAIL PROTECTED] More so will i need to open MySQL server on my local machine before running MySQL client to connect to the remote machine e.g. No. The service (mysqld) is strictly assigned to managing the local database(s) and to serve access to those databases to whomever it sees fit. The question of who is seen as fit is determined by the GRANT statements used earlier. The client simply connects to a MySQL server someplace. That server might be local, or it might be on the other side of the planet. --- Rodney Broom Programmer: Desert.Net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql from different computer
At 03:23 PM 12/10/01 -0700, you wrote: From: Dan [EMAIL PROTECTED] I can connect... on the same computer ...different machine it won't work. I have a similar problem but let explain better may be i don't get what Dan was talking about. From my local computer i can use LOAD command to store values into tables on the same machine. Now I want to be able to do the samething on mysql server at the remote site if i can successful connected to Mysql server on the remote machine. Can this sovle my sleeplessness problem? if not is there any assist you can render to me. Any support will be highly appreciated. Thanks in anticipation for your reply. Best regards. Kamal I suspect that you need to add an entry at the MySQL host for the machine that you are connecting from. This can be done with a GRANT statement: - Format: grant all privileges on databaseName.tableName to 'userName'@'hostName' identified by 'somePassword'; - Example: grant all privileges on myDB.* to 'clyde'@'coolPlace.org' identified by 'secretPass'; Then you'll need to reload the access privileges. It can be done at the command line like this: % mysqladmin -u rootUserName reload Remember, you may need to add the -p switch and suply a password for this command. Is this enough info? --- Rodney Broom Programmer: Desert.Net Spam filter: sql database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql from different computer
From: [EMAIL PROTECTED] I have a similar problem... Just to be sure, it's helpful if you could send us the message that your getting when you see the connection problem, but this sounds like the same thing. Can this sovle my sleeplessness problem? Probably. Anytime I can't sleep, I just look for some sound advice. If that doesn't work, then I like to try some warm milk and a couple of my wife's chocolate chip cookies. --- Rodney Broom Programmer: Desert.Net Spam Filter: sql database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql from different computer
From: Dan [EMAIL PROTECTED] I can connect... on the same computer ...different machine it won't work. I suspect that you need to add an entry at the MySQL host for the machine that you are connecting from. This can be done with a GRANT statement: - Format: grant all privileges on databaseName.tableName to 'userName'@'hostName' identified by 'somePassword'; - Example: grant all privileges on myDB.* to 'clyde'@'coolPlace.org' identified by 'secretPass'; Then you'll need to reload the access privileges. It can be done at the command line like this: % mysqladmin -u rootUserName reload Remember, you may need to add the -p switch and suply a password for this command. Is this enough info? --- Rodney Broom Programmer: Desert.Net Spam filter: sql database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql using tcp/ip
Richard Gibbs wrote: sorry if this is the wrong list I am a beginner user of mysql, but a few pl I know are very active in scripting using mirc, especially gaming using tcp/ip connections to game servers to find out various details. I would like to know how/if I can connect to a mysql database using tcp/ip as mirc allows connections of this type. if anyone has a few hints and/or webpages I can look at to get a good idea of where to go with this it would help immensely. be warned, I am a beginner, but my friends are not so any help at all would be appreciated. No problem about being beginner. We all be beginners sometime. About question: it is pretty senseless. mIRC is IRC client software for Wnidows as much I know. I do not care if has some kind of scripting made on it but there is still no relationship with MySQL database. Yes MySQL uses TCP/IP but you are trying to make something incompatible by idea.If you need database, forget about mIRC. If you need IRC then it is not related to database I believe. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql securely via network
James Gosnell wrote: If I connect to mysql: mysql -u username -p wherever.net is that encrypted at all? No and never will be default behaviour to encrypt communication as this reduces performance. and if I make a network program via the C API, would that be encrypted too? Thanks No. In MySQL 4.0 it will be standard feature to have SSL protected connections when asked to use them. Also there is a different tunneling solutions for them. Search for words CIPE or SSL tunnel with search engines and you get right to the point. Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL w/VB
Give MyODBC a try, its on the mysql.com site and its given my no problems at all in vb. Sean -Original Message- From: Robert Skinner [mailto:[EMAIL PROTECTED]] Sent: Friday, June 29, 2001 3:45 AM To: [EMAIL PROTECTED] Subject: Connecting to MySQL w/VB I am trying to connect to MySQL using a connection string using VB6. The read part is great but I don't seem to be able to add records. Can anyone steer me in the right direction? [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL w/VB
I am using a DLL called MYVBQL.dll which is also on the mysql web site and it works like a dream. Don't need no ODBC driver, and all that stuff. Similar to ADO but also quite different. Some bugs but if you stick to SQL statements to insert/update/delete info it works like a dream and is very fast. Regards ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of [EMAIL PROTECTED] Sent: 29 June 2001 10:41 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Connecting to MySQL w/VB Give MyODBC a try, its on the mysql.com site and its given my no problems at all in vb. Sean -Original Message- From: Robert Skinner [mailto:[EMAIL PROTECTED]] Sent: Friday, June 29, 2001 3:45 AM To: [EMAIL PROTECTED] Subject: Connecting to MySQL w/VB I am trying to connect to MySQL using a connection string using VB6. The read part is great but I don't seem to be able to add records. Can anyone steer me in the right direction? [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySQL w/VB
- Original Message - From: Robert Skinner [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 7:44 PM Subject: Connecting to MySQL w/VB I am trying to connect to MySQL using a connection string using VB6. The read part is great but I don't seem to be able to add records. Can anyone steer me in the right direction? A bit more information might help us help you. If you the db reads work fine, then you at least have the connection made - that's already half-way there! I have done extensive work with MySQL and VB/VBScript, but if you can execute a SELECT query (as your e-mail indicates) I don't see how you would have problems executing an INSERT query (assuming the SQL statement is valid). What exactly seems to be the problem? Good Luck, Dennis ** Beridney Computer Services http://www.beridney.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySQL w/VB
i know i am definitly knew at this, but his permissions could be set more or less for read only. i am just spitting junk out, i am new, but i don't like sitting idle in a group. i have been watching this thread closely, because i do developement on a large scale in ASP and VB. so just ignore me if i am being an idiot. Jason - Original Message - From: Dennis Salguero [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 11:03 PM Subject: Re: Connecting to MySQL w/VB - Original Message - From: Robert Skinner [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 7:44 PM Subject: Connecting to MySQL w/VB I am trying to connect to MySQL using a connection string using VB6. The read part is great but I don't seem to be able to add records. Can anyone steer me in the right direction? A bit more information might help us help you. If you the db reads work fine, then you at least have the connection made - that's already half-way there! I have done extensive work with MySQL and VB/VBScript, but if you can execute a SELECT query (as your e-mail indicates) I don't see how you would have problems executing an INSERT query (assuming the SQL statement is valid). What exactly seems to be the problem? Good Luck, Dennis ** Beridney Computer Services http://www.beridney.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySQL w/VB
- Original Message - From: Jason Brunk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 8:18 PM Subject: Re: Connecting to MySQL w/VB i know i am definitly knew at this, but his permissions could be set more or less for read only. Yes, it's possible that the permissions are not set properly. However, I was assuming that, since he had just started working with MySQL, he was using the root account, unmodified, which would give him complete access. It's been my experience that it is much easier to work with ASP MySQL than VB MySQL because of the databound objects, and wouldn't be surprised if the problem that the original poster has does not apply to ASP. Good Luck, Dennis ** Beridney Computer Services http://www.beridney.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySQL w/VB
just curious, how do you connect to mysql through ASP? i have tried connecting with MyODBC, i installed myodbc and then i create the connection string in asp like this set conn=server.createobject(adodb.connection) conn.open driver={mysql};server=192.168.0.1;user=user;pass=pass;database=db1 i was just curious to see how you connect to mysql with asp jason asp developer working in mysql :) - Original Message - From: Dennis Salguero [EMAIL PROTECTED] To: Jason Brunk [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 11:38 PM Subject: Re: Connecting to MySQL w/VB - Original Message - From: Jason Brunk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 8:18 PM Subject: Re: Connecting to MySQL w/VB i know i am definitly knew at this, but his permissions could be set more or less for read only. Yes, it's possible that the permissions are not set properly. However, I was assuming that, since he had just started working with MySQL, he was using the root account, unmodified, which would give him complete access. It's been my experience that it is much easier to work with ASP MySQL than VB MySQL because of the databound objects, and wouldn't be surprised if the problem that the original poster has does not apply to ASP. Good Luck, Dennis ** Beridney Computer Services http://www.beridney.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to mysql as root
For connecting I have given the user as root and no password in the PERL scipt. You NEED to provide the password otherwise you can't get any data out of the database.. If you didn't entered a password for the mysql root user you need to do it ASAP.. Is there any way to connect to the database in the normal way, I mean from the shell ? mysql -u root -p then you're asked to enter your password use name_of_database Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql using php
This is a real RTFM, but here we go: On Thu, Apr 12, 2001 at 04:03:20PM -0700, josh kneedler wrote: i'm trying to connect to mysql using php so that i can do web based queries of my tables. i'm new at this so here are some questions: 1. is localhost just the ip of my server Yes. Or just the word 'localhost'. Or your full server name. 2. if root is the login name should it be my login or just stay as root? The name of the account you want to use to connect to the database. 3. is mypasswd the same password i enter when i'm in the mysql evironment in reference to (mysql -u root -p)? Yes. once i can declare the dbcnx variable i'll be able to do queries with php. josh // Connect to the database server $dbcnx = @mysql_connect("localhost", "root", "mypasswd"); if (!$dbcnx) { echo( "PUnable to connect to the " . "database server at this time./P" ); exit(); } -- dreaming america : visual media studio 503.222.2242 : http://dreamingamerica.com ...:::. http://rangermag.com :::...:::.:.v.1.i.2...:: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql using php
Let me explain a little further. - Original Message - From: "josh kneedler" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 13, 2001 7:03 Subject: connecting to mysql using php i'm trying to connect to mysql using php so that i can do web based queries of my tables. i'm new at this so here are some questions: 1. is localhost just the ip of my server or is it also the path to where mysql is on my server? Using the word localhost is only used when mysql server is on the same machine as your web server otherwise you need ip address or full host name. 2. if root is the login name should it be my login or just stay as root? Not a good idea to use root, create another user with restricted access. 3. is mypasswd the same password i enter when i'm in the mysql evironment in reference to (mysql -u root -p)? once i can declare the dbcnx variable i'll be able to do queries with php. josh // Connect to the database server $dbcnx = @mysql_connect("localhost", "root", "mypasswd"); if (!$dbcnx) { echo( "PUnable to connect to the " . "database server at this time./P" ); exit(); } -- dreaming america : visual media studio 503.222.2242 : http://dreamingamerica.com ...:::. http://rangermag.com :::...:::.:.v.1.i.2...:: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql using php
On 12 Apr 2001, at 16:03, josh kneedler wrote: i'm trying to connect to mysql using php so that i can do web based queries of my tables. i'm new at this so here are some questions: 1. is localhost just the ip of my server or is it also the path to where mysql is on my server? Just the hostname or IP. MySQL runs wth port 3306 by default so when you do @mysql_connect("localhost", "root", "mypasswd"); you will be automagically connected to the MySQL server. You then need to determine which database to use, eg: mysql_select_db($DBNAME, $db); $DBNAME is the database, $db the connection you opened. 2. if root is the login name should it be my login or just stay as root? Which login do you mean? The *NIX login or your MySQL user name? You should set up a user in MySQL user table with the appropriate privileges and log in as that user. 3. is mypasswd the same password i enter when i'm in the mysql evironment in reference to (mysql -u root -p)? Yes, see 2 above also. David once i can declare the dbcnx variable i'll be able to do queries with php. josh // Connect to the database server $dbcnx = @mysql_connect("localhost", "root", "mypasswd"); if (!$dbcnx) { echo( "PUnable to connect to the " . "database server at this time./P" ); exit(); } -- dreaming america : visual media studio 503.222.2242 : http://dreamingamerica.com ...:::. http://rangermag.com :::...:::.:.v.1.i.2...:: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySQL with Visual Basic
Someone sent me some samples of various connection type (ADO, DAO, etc) about a month ago but I'll post off list. - Original Message - From: "Dwight Mowbray" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 19, 2001 10:18 Subject: Connecting to MySQL with Visual Basic Hi. Can anyone tell me how or refer me to any tutorials on how to connect to mysql using Microsoft Visual Basic (v. 6)? Any help would be much appreciated. Thanks. Kind regards, Dwight Mowbray. E-commerce solutions provider. Email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php