Re: Mysql and Windows ME?

At 00:18 26/5/2001 -0500, Paul DuBois wrote: Hi, Only to complete the Paul's instructions, use mysqld-max.exe on Win ME, because mysqld.exe (only for this distribution) doesn't run on Win9x and Win ME OSs. If you don't want InnoDB tables, use mysqld-opt.exe. Regards, Miguel At 5:13 AM +

MySQL network interface

hi list, I have mysql installed on SuSE 7.0 box with 2 network interfaces and I want port 3306 to be opened only on one of them (internal). Is there any options in mysql configuration to achieve this? thank you, -- [EMAIL PROTECTED]

Install problem

Hi, I try to install mysql 3.23.27-beta, but when i execute ./configure --prefix=/usr/local/mysql i ha ve an error message saying that it can't create executable file so i install gcc 2.95.2 and make 3.77, but it's same What can i do? François

Pending results...

Im having trouble with 'to many pending results' in MySQL. Any ideas? - amund

Re: MySQL network interface

man ipchains - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, May 26, 2001 8:44 AM Subject: MySQL network interface hi list, I have mysql installed on SuSE 7.0 box with 2 network interfaces and I want port 3306 to be opened only on one of them

PROBLEMS PHPMYADMIN AND MYSQL

Dear confrators, I use phpMyAdmin on Mysql servers to exchange data also to different platforms, but with large databases, this is not a very good way to transfer complete databases, also phpMyAdmin gives somethimes problems on Windows platforms, what is the best, fastest way to transfer data

Orbital casino

Thanks for help!

Thanks for advices. As I got the error message, I thought the server has not been started. It runs really! Frank Tu From: Miguel Angel Solórzano [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED],tu tuande [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Mysql and Windows ME? Date: Sat, 26

Re: Compilation problems.

Nicu Popovici writes: Hello Eric, Ofcourse that my file has such a thing. Otherwise how can it recognizes the MYSQL data type ? I have a line like this MYSQL mysql; But the problem appear at linking time so I do not think that the compilation passes without to know where to find

Re: Compilation problems.

Hello Sinisa, Here it is the line with which I try to compile the program. -- [nicu@ares QA]$ gcc -g Bug_Report.c -o test.o -L/usr/lib/mysql/libmysqlclient -I/usr/include/mysql -lmysqlclient -lnsl /tmp/ccGABNJr.o: In function `main': /home/nicu/QA/Bug_Report.c:7: undefined

Re: Compilation problems.

Hi Sinisa, I looked on the symbols from libmysqlclient.a and indeed there is no mysql_init or mysql_real_connect there . There are mysql_kill and some other functions but the first two there are not. Regards, Nicu Sinisa Milivojevic wrote: Nicu Popovici writes: Hello Eric, Ofcourse

Re: $dbh-tables, SHOW tables, etc.

Daniel wrote: Scratch that, normally egcs and gcc are the same, at least on older redhat distros. Redhat 7.0 gives you compat-egcs package which isn't the same as your gcc. I symlinked (on a 7.1 redhat box) egcs to gcc (2.96-69) and --rebuild 3.23.38 from the .src.rpm. Both show tables,

Please How can I password protect my database?

Hello, I use telnet to manage my mysql database, Please How can I password protect my database, or the database directory. Thanx ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com

Re: Compilation problems.

Hello Gurus, I managed to compile and link my sample file substituting mysql_init() with my_init() and mysql_real_connect() to mysql_connect(). I get now the following error -- Failed to connect to database! Error jHost 'ares.main.ro' is not allowed to connect to this MySQL

Re: Compilation problems.

Nicu Popovici writes: Hello Gurus, I managed to compile and link my sample file substituting mysql_init() with my_init() and mysql_real_connect() to mysql_connect(). I get now the following error -- Failed to connect to database! Error jHost 'ares.main.ro' is not

Re: Compilation problems.

Hi Sinisa, You are right , I did a select * from user and the host field is indeed localhost. How can I update that field , and I do not have a host table. Should I modify anly this table or not ? Another question, how can I add a user and also a machine ( host field ) ? I want to set up a

Re: Compilation problems.

Nicu Popovici writes: Hi Sinisa, You are right , I did a select * from user and the host field is indeed localhost. How can I update that field , and I do not have a host table. Should I modify anly this table or not ? Another question, how can I add a user and also a machine ( host

Re: Compilation problems.

Hi Sinisa, I get another error now. It seems that I managed to pass by that error. Here it is what I get now: -- Failed to connect to database! Error Protocol mismatch. Server Version = 10 Client Version = 9 ; -- What shall I do ? Regards, Nicu Sinisa

Re: Compilation problems.

Nicu Popovici writes: Hi Sinisa, I get another error now. It seems that I managed to pass by that error. Here it is what I get now: -- Failed to connect to database! Error Protocol mismatch. Server Version = 10 Client Version = 9 ; -- What shall I

Connection problem...

I cannot seem to connect to a remote mySQL server located at my ISP. I basically downloaded mysqlgui-win32-static-1.7.4-2.zip and installed. filled in the server information. database name and username then tried to connect. WHen I try to connect it tells me Access denied for user:

Re: PROBLEMS PHPMYADMIN AND MYSQL

Yves Soete wrote: Dear confrators, I use phpMyAdmin on Mysql servers to exchange data also to different platforms, but with large databases, this is not a very good way to transfer complete databases, also phpMyAdmin gives somethimes problems on Windows platforms, what is the best,

socket questions

Hi, I recently had some questions about converting files and haven't had the chance to work further with it or thank everyone for the help. So thanks a lot.I found that my application needed to have a dedicated MySQL installation. There is another version of MySQL running on this machine

heavy load configuration

I have a Linux box running mysql and apache, and we are expecting quite a load on the 1st of June. We have an application form whose data will be written into a db on the same server and I would like to know what I can do to make sure things go smooth. The machine is an AMD 500, with 320MB RAM,

Delayed insert

Hello, I am having some troubles with INSERT DELAYED statement... even when there are NO pending select, update or delete statements (I can see at the SHOW PROCESSLIST query) , still it keeps waiting... This is the info of the delayed process that doesn't want to execute: db: antrophi command:

Re: heavy load configuration

You should get an identical 20gig IDE drive to 'mirror' the O/S partitions, and since you have a SCSI setup for the data areas, you should get at least 2 more of those, and 'stripe' the data across them (or at least get a second drive to 'mirror' those partitions as well).Though 'mirroring'

mysql_config broken

Hi! long == long [EMAIL PROTECTED] writes: Description: long The mysql_config script contains the following line: long if ! test $# -gt 0; then usage; fi long which according to my sh man page doesn't work because ! isn't valid and in long fact when I run it on Compaq Tru64 4.0F PK3 I

Re: heavy load configuration

At 06:34 PM 5/26/2001 +0200, P.Agenbag wrote: How will I know if my server is up to it, or should I rather say, how many consecutive users will this box be able to handle? The line shouldn't be a problem, I think it sits on a couple of 100 MB/s line. Well.. this is one topic I sorta

Re: Compilation problems.

Hello Sinisa, I managed to get a connection to a database but now when I want to try to make a query on that database I have to use strmov() function defined in m_string.h but at compilation time I get the following errors. JUST BECAUSE I INCLUDED m_string.h into my file

login

Hello I need to build a site like www.charitymall.com is this possible with MySQL? I need a login then you pic a charity that gives you a new user name then that is attached to thingsd you purchase a percentage goes to the charity of your choice Thanks Tim

Re: mysql_config broken

In the last episode of the mysql list (May 26), Michael Widenius said: Fix: long Change the problem line from: long if ! test $# -gt 0; then usage; fi long to: long if test $# -le 0; then usage; fi I have now fixed this for the upcoming 3.23.39. Thanks! The more general

[MySQL] Reporting time in Greenwich Mean Time

Hi, I've got a time/date stamp for a database I'm working on which logs the last time and date that any changes were made to the database. What I'd like to be able to do is have the time be set to Greenwich Mean Time rather than the local time of the server. Current I'm using NOW() to enter

Re: login

Tim: MySQL can certainly do the job on the backend ... but the more critical decision is the selection of the shopping cart software. Shopping carts range from free/GPL/Open Source to many thousands of dollars. There are carts available that use perl, cgi, PHP ... not all support MySQL, but the

User privs in mysql

hi List I have a database in mysql that has to be used as root user. When I try and use it as normal user (gordon) it complains. I have inserted the user gordon into the mysql database and it has all privs but it still has the problem. I can not even create a database as the user gordon. I

Relocate DB

I just downloaded mysql_3.23.38.tar.gz and I am trying to set it up on an i386 FreeBSD 4.3 box. I am trying to get the databases on a diffrent partition then the program. The current line I used to configure it was ./configure --prefix=/usr/local/mysql --localstatedir=/var/db . I did this

RE: Install help

Ther are alot of good tutorial sites on this but here's one http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/page1.html Do a Web Search MySQL Tutorial or MySQL PHP Cheers Mike -Original Message- From: Simon Shearer [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 26, 2001 9:33

atttempting to connect remotely using mysql gui

I'm using the mysql gui client on a windows machine and attempting to connect to mysql on a linux machine for the purpose of doing some database design. I can't get a connection, however. I get the following error message: access denied for user username@userip address (using password: YES)

RE: Relocate DB

On 27-May-01 Myke Corredera wrote: I just downloaded mysql_3.23.38.tar.gz and I am trying to set it up on an i386 FreeBSD 4.3 box. I am trying to get the databases on a diffrent partition then the program. The current line I used to configure it was ./configure --prefix=/usr/local/mysql

installing mysql(password??)

when you first install mysql server does it assign a default password becuase it tells me to enter these in to make a password for my server, but I don't know what the heck to do with them, but when I try them it says access denied /usr/bin/mysqladmin -u root -p password 'new-password'

RE: installing mysql(password??)

Go to http://www.mysql.com/doc/C/o/Connecting.html and also read through http://www.fsai.fh-trier.de/system/doku/MySQL/manual_Privilege_system.html#C onnecting In the Linux source download there is also a script to reset the user and password, which was root and no password. Hope it helps ;-)