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 ;-) -

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' /usr/bi

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/mys

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 @ (using password: YES) I'm rather new to mysql

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 P

Install help

Help! Trying to install Mysql, Php and Apache on Win 2k computer. Can't get mysql or php to work. Read all three manuals and still doesn't seen to work. Thanks in advance. Simon - Before posting, please check: http://www

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 becau

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 ha

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

[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: 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

C API for mysql : could not find compress : examples foc compiling and linking

Hi, I'm working on my first program witk mysql c api. I meet problem to link c program that use it. One symbol "compress" cannot be resolved. Has anybody a sample script that compile and link ? What are the options to compile and link ? Thanks a lot. Bye

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: 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

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 specia

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

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' w

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:

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, 25

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 (Red

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,

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: 'myUsername

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 ; > -- > >

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 Miliv

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

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: > 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 n

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

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: $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

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, > > > > Ofc

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 r

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 t

Re: Compilation problems.

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 the definitions for all the code th

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? >Da

Orbital casino

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 bet

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 th

Pending results...

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

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

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] ---