SQL command for MySQL ?
Hi i am debutant in SQL and i am search to know if it's possible: My SQL requets: UPDATE Table_Logs_Summary SET mails_recus=(mails_recus+1),mail_rbl=(mail_rbl+1) WHERE dom_id=4 AND Date_Start=2010-03-16 06:00:00 AND Date_End=2010-03-16 06:59:59; I wan't know if they have a optimised sql requets for said if the WHERE don't exist, he create it ! (if he don't have dom_id=4 AND Date_Start=2010-03-16 06:00:00 AND Date_End=2010-03-16 06:59:59 he create by in INSERT) (a IF NO EXIST ?) thanks Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Mysql Performence config ?
Hi i use MySQL Server 5.1.42 on a IBM Xseries x3950 (32Go,4xDual Core,Mandriva 64 Bits, 250 GoRAID SAS). I search the best my.cnf configuration for performence, actually i use : [client] port= 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port= 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer_size = 256M max_allowed_packet = 1M table_open_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size= 16M thread_concurrency = 8 log-bin=mysql-bin binlog_format=mixed server-id = 1 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout On this serveur, i have 3 database with a table of ~30 000 000 of entry for ~3.5Go Thanks for your help Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Charset and collation question
Hi all, Which charset and collatio would be the most suitable for a french / english system? Thanks Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
my-medium vs my-huge cnf files
Hi, I'm quite new to mysql and I have a question regarding the server configuration files. I have a server with 2 go of memory and I would like to know the reason why when I run a query (select * from Mytable) that returns 400k rows the my-medium configuration always runs the query in 30 sec and the my-huge configuration runs it in about 35 to 50 sec its never the same. Doesn't the my-huge suppose to be more efficient and faster when you have the memory to handle it? Or will I only see a difference running a test with multiple concurrent queries? Thanks in advance! Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql overall stability
Hi all, I've was wondering if anyone is using MySql as their main ERP production database, if so how stable and reliable is it? Thanks for your comments Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems with decimal numbers
Hello, When I try to insert decimal numbers like 12857.59, 13858.58 or 14785.60, they are inserted as 12857.58, 13858.57 and 14785.59 ?! DataType is DECIMAL 10,2 Any idea of a way to avoid this annoying issue ? Thanks. Regards. Stéphane. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SET PASSWORD = PASSWORD('newpassword') does not work if user has host extension
I am using MySQL 4.0.18 on Windows.
I want to give my users the possibility to change their MySQL password after
they log in.
The command SET PASSWORD = PASSWORD('newpassword') works fine as long as the
user has been created with no specific host extension in the mysql database
(corresponding to e.g. [EMAIL PROTECTED]). Now if the user is defined in the mysql
database with a host extension ([EMAIL PROTECTED], for example), the SET
PASSWORD command fails with the message Can't find any matching row in the
user table.
For security reasons, I need the users to be defined with a host extension.
Is this a bug, or is there a way around this?
(Please do not suggest to use SET PASSWORD FOR [EMAIL PROTECTED] = PASSWORD
('newpassword') as this is only allowed for users that have access to the mysql
database!)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: SET PASSWORD = PASSWORD('newpassword') does not work if user has host extension
Right on!
Effectively, user() returns the dns resolved name. So obviously this will
not match the mysql user table entry, where the ip range is specified.
I will try the --skip-name-resolve option, but I have to wait for a
scheduled down time of the server.
Thanks for the expert advice!
At 14:29 13/07/2004, you wrote:
When that user does a select user() are they receiving the numeric ip
address or the dns resolved name? If you set up the privilege with the
numeric ip and dns is resolving this the two values will not match. If
necessary you can use --skip-name-resolve.
-Original Message-
From: Stephane Carre
To: [EMAIL PROTECTED]
Sent: 7/13/04 5:01 AM
Subject: SET PASSWORD = PASSWORD('newpassword') does not work if user has
host extension
I am using MySQL 4.0.18 on Windows.
I want to give my users the possibility to change their MySQL password
after
they log in.
The command SET PASSWORD = PASSWORD('newpassword') works fine as long as
the
user has been created with no specific host extension in the mysql
database
(corresponding to e.g. [EMAIL PROTECTED]). Now if the user is defined in the
mysql
database with a host extension ([EMAIL PROTECTED], for example), the
SET
PASSWORD command fails with the message Can't find any matching row in
the
user table.
For security reasons, I need the users to be defined with a host
extension.
Is this a bug, or is there a way around this?
(Please do not suggest to use SET PASSWORD FOR [EMAIL PROTECTED] =
PASSWORD
('newpassword') as this is only allowed for users that have access to
the mysql
database!)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld got signal 11;
I've been searching the mailing list for a solution to my problem with mysqld got signal 11; and I haven't seen any answers that might help me. This is the situation. I have a db that is being accessed intensively about 400 connections during the wee at a time. I noticed the problem at first with 4.0.13 and tried 3.23.57 and now 4.0.14 with the same problem. I've run the db on FreeBSD 5.1 and 4.8, again same problem. This is what shows up in the error log: -- mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=33554432 read_buffer_size=520192 max_used_connections=97 max_connections=450 threads_connected=85 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 491764 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Number of processes running now: 0 030726 06:14:51 mysqld restarted 030726 6:14:51 InnoDB: Started /usr/local/libexec/mysqld: ready for connections. Version: '4.0.14-debug-log' socket: '/tmp/mysql.sock' port: 3306 -- As you can see I have recently compiled 4.0.14 in debug mode and doing some more logging. However I'm still not seeing any further information to help me figure out what is causing this signal 11. The db is accesed remotely via web based php scripts as well as command line php scripts. I've tried to reproduce a test case as described on the on-line MySQL manual ( E.1.6 Making a Test Case If You Experience Table Corruption ) but I can't seem to reproduce the problem. It just seems to singal 11 randomly. When I had a Master/slave setup, only the master would signal 11, the slave seemed completely unaffected, however nothing was accessing the slave directly, I had setup the slave purely as a bit of a remote backup solution for the db. What else can I do to help troubleshoot my problem? I've been looking into stack trace and trace files but I'm not sure if these would help me out. Does anyone have any suggestions for me to try and what other information I might be able to provide? Thank you, Stephane Raimbault. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Storing a BLOB in a MySQL database with the MySQL C API
i have a problem with my project :-) i created two functions, base64_encode, and base64_decode, to insert a binary file in a LONGBLOB field. When i use theses functions without a buffer i don't get errors. by example : OUTPUT = base64_decode(base64_encode(INPUT)); -- i don't have errors, i can compare the OUTPUT with the INPUT, and i don't have errors. But when i use a temporary buffer, i have an error. i have this problem with my mysql database. there is a differenct character. perhaps I have an error in my transfer of data with MySQL, or with a simple char *tmp Could i send you my code ? because i don't find the solution of my problem. Best Regards Stephane Wirtel - 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: how to change mysql root password
Hi everyone.. I have a related problem with my mysql 3.23.54 on a RH7.3... Assigning the root password is ok with Mysqladmin -u root password 'newpassword' but when trying to do Mysqladmin -u root -h myhost.mydomain.tld password 'newpassword' i have the following... ./mysqladmin: connect to server at 'myhost.mydomain.tld' failed error: 'Can't connect to MySQL server on 'myhost.mydomain.tld' (111)' Check that mysqld is running on myhost.mydomain.tld and that the port is 3306. You can check this by doing 'telnet myhost.mydomain.tld 3306' Telnet refuses my connexion, even though i'm connecting from the host itself... Anyone has a clue for this ?... Regards steph -Original Message- From: Jianping Zhu [mailto:[EMAIL PROTECTED]] Sent: vendredi 31 janvier 2003 21:46 To: [EMAIL PROTECTED] Subject: how to change mysql root password How to change mysql root password in redhat 7.3 ? Thanks - 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
Storing a BLOB in a MySQL database with the MySQL C API
Hi all !
I would like to insert a Blob ( a picture exactly ), here is a small
source code to test my insert.
You can find 2 sources code, the first is to insert a blob in a table of
a database ( this database exists in my MySQL server )
And the second code is to read this blob from the database.
I think there are a lot of mistakes, could you help me ? because i did
not find the solution.
thanks
#include mysql/mysql.h
#include stdio.h
#include stdlib.h
#include string.h
#include unistd.h
#include sys/stat.h
#include fcntl.h
#include glib.h
int main(int argc, char **argv)
{
MYSQL *mysql = NULL;
struct stat statbuf;
int file;
unsigned long size, ssize;
gchar *data = NULL, *query = NULL, *end = NULL;
int i;
mysql = (MYSQL *) g_malloc0(sizeof(MYSQL));
mysql_init(mysql);
mysql = mysql_real_connect(mysql, localhost,test, ,
test_stef, 0, NULL, 0);
file = open(photo.png, O_RDONLY);
//file = open(test_mozilla.c, O_RDONLY);
if ( !file )
g_error(Impossible d'ouvrir le fichier photo.png);
fstat(file, statbuf);
fprintf(stdout, Size of photo.png : %ld\n, statbuf.st_size);
size = statbuf.st_size;
data = (gchar *) g_malloc0(size);
if ( !data )
g_error(Impossible de charger la mémoire requise);
ssize = read(file, data, size);
if ( ssize == size )
g_message(Fichier correctement lu);
query = (gchar *) g_malloc0(2*size);
strcpy(query, INSERT INTO test VALUES();
end = query + strlen(query);
*end++ = '\'';
gchar * debut, *fin;
debut = end;
end += mysql_real_escape_string(mysql, end, data, size);
fin = end;
fprintf(stdout, Difference : %lu\n,(unsigned long) (fin - debut));
*end++ = '\'';
*end++ = ')';
/*for ( i = 0 ; i 30 ; i++ )
fprintf(stdout, %c, query[i]);*/
if ( mysql_real_query(mysql, query, (unsigned long) ( end - query )) )
{
g_error(Erreur lors de la requete d'insertion dans la DB);
}
g_free(data);
g_free(query);
mysql_close(mysql);
return 0;
}
But when i edit the mysql database with mysqlcc utility, i don't the
complete file.
now, when i read the Blob from the database, i use this source code.
#include glib.h
#include mysql/mysql.h
#include stdio.h
#include string.h
#include stdlib.h
int main(int argc, char **argv)
{
MYSQL *mysql = NULL;
MYSQL_RES *mysql_res = NULL;
MYSQL_FIELD *mysql_field = NULL;
MYSQL_ROW *mysql_row = NULL;
gchar query[] = SELECT photo FROM test;
mysql = (MYSQL *) g_malloc(sizeof(MYSQL));
mysql_init(mysql);
if( !mysql_real_connect(mysql, localhost, test, ,
test_stef,0, NULL, 0) )
g_error(Failed to connect to database : Error : %s\n,
mysql_error(mysql));
if (mysql_real_query(mysql, query, strlen(query)))
g_error(Failed query to database : Error : %s\n,
mysql_error(mysql));
if ( !(mysql_res = mysql_store_result(mysql)) )
g_error(Failed Store Result : Error : %s\n, mysql_error(mysql));
mysql_field = mysql_fetch_field(mysql_res);
g_print(Field name : %s\n, mysql_field-name);
mysql_row = mysql_fetch_row(mysql_res);
FILE *fichier;
fichier = fopen(photo_2.png, wb);
fwrite(mysql_row[0], strlen(mysql_row[0]), 1, fichier);
fclose(fichier);
mysql_close(mysql);
g_free(mysql);
return 0;
}
Thanks
Stephane Wirtel
-
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
How to insert an Image in a table with libmysqlclient and API C ?
Hi all, my problem is the following, it's possible to insert an image in a table with the libmysqlclient ? My language is C i'm working with GNU/Linux Best Regards, Stephane Wirtel - 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
pbm on install 3.23.54
Hi everyone... I have a problem, but maybe not related to mysql itself, for i have installed a RPM first, then deleted it, then tried the 4.0.5, then tried the 3.23.54, and still have the same problem... So here's the story Regarding the 3.23.54 install. I downloaded the source tar.gz... Put it in my home directory and typed : tar xzvf mysql then ./configure --prefix=/usr/local/mysql then make after this, as root, make install cd /usr/local/mysql ./bin/mysql_install_db chown -R mysql var chgrp -R mysql . then ./bin/safe_mysqld -u mysql but here's the first problem : ./bin/safe_mysqld: 5: command not found still, mysql seems to be running despite this error. But when trying to assign root a password, I can set it with mysqladmin -u root password 'myownpass', but can't set the mysqladmin -u root -h myhost.mydomain.mytld password 'myownpass'... the error is : ./bin/mysqladmin: connect to server at 'myhost.mydomain.mytld' failed error: 'Can't connect to MySQL server on 'myhost.mydomain.mytld' (111)' Check that mysqld is running on myhost.mydomain.mytld and that the port is 3306. You can check this by doing 'telnet myhost.mydomain.mytld 3306' when i go telnet on the box, i get a connexion refused so i thought that i could explicitly open the 3306, but it didn't changed anything. I created a my.cnf within which i have : [client] port= 3306 socket = /tmp/mysql.sock # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K datadir = /usr/local/mysql/var # Start logging log [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=16M So my question is, does anybody sees why i have these errors ? I run with a RH7.3 TIA Stephane - 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
table Mysql.user doesn't exist
Hi everyone, I'm trying to setup a mysql base upon a RH7.3 server. The mysql version is the 3.23.52. I'm trying to re-install it from the sources (as already did)... Mysql used to run, but i tried to install the perl::dbi and i did things that might not have done good to the thing... So I decided to go back, saved the DBs and re-install mysql But i'm facing the pbm when i try to assign the root passwd : unable to change password; error: 'Table 'mysql.user' doesn't exist' What can I do ?... i searched the table but did not find it Every help would be h helpful (c) monty python Regards Stephane - 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: Re MySQL on Redhat 7.3
- Original Message - From: Peter Goggin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 17, 2002 3:55 PM Subject: Re: Re MySQL on Redhat 7.3 I have got the msql server running and now need to configure it. In particular I want to set it up to use innodb tables. When I set up mysql on win98 I used the mysql-max release which comes with built in Innodb support and provides sample my.cnf files with the instructions for setting up Innodb table spaces. I cannot find anything similar from the RedHat installation. The rpms installed are: mysql-3.23.49-3 mysql-devel-3.23.49-3 mysql-client9-3.23.22-6 mysql-server3.23.49-3 On looking at the mysql site, it looks as though I need another rpm, mysql-max-3.23.49-3 which should be installed after the others. Is this correct and if so where can I down load it. (the current version is 3.23.52) i may be wrong but i guess you shouldn't need mysqlmax... all you need is to specify that you want innodb at the compile time. For this, you should get the source and not the binaries when you untar your mysql tar.gz (by the way, why not using the last one 3.23.52 ?), you'll find a file called INSTALL-SOURCE in which you'll read : * If you want to configure `mysqld' with some extra features that are NOT in the standard binary distributions. Here is a list of the most common extra options that you may want to use: * `--with-berkeley-db' * `--with-innodb' * `--with-raid' * `--with-libwrap' * `--with-named-z-lib (This is done for some of the binaries)' * `--with-debug[=full]' Have fun ;-)) Stephane - 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
Connect to MySQL using TCP/IP securely
How can I connect to a distant MySQL Server -using tcp/ip- securely ? Thanks Stéphane - 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
Compiling mysql on HP-UX
I want to install my sql on an HP-UX 10.20. I made ./configure with the options for HP-UX 10.20, as on the officiel site and I had no problem. But when I do make, I have this error : why ? gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I.. -D__STDC_EXT__ -O3 -DDBUG_OFF -DHPUX -I/opt/dce/include -fpic -DHAVE_BROKEN_SNPRINTF -DSIGNALS_DONT_BREAK_READ -DDO_NOT_REMOVE_THREAD_WRAPPERS -DHPUX -DSIGNAL_WITH_VIO_CLOSE -c rltty.c command line: warning: __STDC_EXT__ redefined command line: warning: this is the location of the previous definition rltty.c: In function `set_tty_settings': rltty.c:231: `TIOCSETN' undeclared (first use in this function) rltty.c:231: (Each undeclared identifier is reported only once rltty.c:231: for each function it appears in.) rltty.c: In function `prepare_terminal_settings': rltty.c:286: `CBREAK' undeclared (first use in this function) *** Error exit code 1 Stop. What do I have to do ? Thank you - 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
Compiling on apache.
I have a problem with compiling mysql on HP-UX. I can't compile because it doesn't know that I have gcc. I have this error with ./configure : checking for gcc... cc checking whether the C compiler (cc -Ae -D_REENTRANT ) works... yes checking whether the C compiler (cc -Ae -D_REENTRANT ) is a cross-compiler... no checking whether we are using GNU C... no checking whether cc accepts -g... yes checking for c++... aCC checking whether the C++ compiler (aCC -D_REENTRANT ) works... no configure: error: installation or configuration problem: C++ compiler cannot create executables. what do i have to do ? tks - 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
Commands...
Hi all, Have installed: mysql Ver 11.16 Distrib 3.23.49, for Win95/Win98 (i32) I use a Win2K Pro, and downloaded it from http://www.myqsl.com The problem is that a lot of commands are missing, like CREATE TABLE, or even SHOW TABLE Any help? Regards Steph - 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: Commands...
Hi Roger, It was may be a bad way to expressed. I mean, I can't type the commands in DOS window, there are no .exe Actually, would like to type my commands in text mod. Regards Steph - Original Message - From: Roger Baklund [EMAIL PROTECTED] To: 'mysql' [EMAIL PROTECTED] Cc: Stephane Collas [EMAIL PROTECTED] Sent: Sunday, March 03, 2002 7:20 PM Subject: RE: Commands... * Stephane Collas Have installed: mysql Ver 11.16 Distrib 3.23.49, for Win95/Win98 (i32) I use a Win2K Pro, and downloaded it from http://www.myqsl.com The problem is that a lot of commands are missing, like CREATE TABLE, or even SHOW TABLE What do you mean commands are missing...? Do you get an error message when you try to use these commands? Can you show us what you have tried and the error message you get? There is no command called SHOW TABLE... maybe you mean SHOW CREATE TABLE or SHOW TABLE STATUS? -- Roger query - 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
[NEWBIE]Can't run mysql client
I've installed mysql 3.23.47 (Binaries) on a Linux RedHat 7.0 box. Everything seems to be OK (the server runs) but I cannot connect to it using mysql client: When I enter mysql -u etc... I've got a bash: mysql: command not found Any idea ? Thanks -- Stéphane Pinel 39, Rue du Docteur Heulin 75017 Paris (FRANCE) 33 1 53 11 05 77 33 6 08 94 63 16 [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
Re: upgrade from SUSE7.0 solution...
David Simmons - EliteUKServe.Net wrote: what I had to do was download and install: http://www.mysql.com/Downloads/MySQL-3.23/MySQL-client-3.23.38-1.i386.rpm http://www.mysql.com/Downloads/MySQL-3.23/MySQL-devel-3.23.38-1.i386.rpm as well. removing the originals via yast if i remember i had a few glitches with dependencies with the rpm's. I upgraded the mysql provided by suse with the 3.23.37, and I have a problem... It's said that i have to change the root user with /user/bin/mysqladmin -u root -h mycomputer -p password 'new-password'. well... at the very first attempt, of course, the -p is not to be used, and everything goes fine Is it me or the installation doc that is to blame ? would it be possible to have lines such as : /usr/bin/mysqladmin -u root -h localhost password 'your_password_here' instead of /usr/bin/mysqladmin -u root -h localhost password 'new-password' -p ?... thanks for the answer given on this list... Stephane - 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: upgrade from SUSE7.0
Andy Woo wrote: I have the same problem. Whatsssup? :-) /usr/bin/mysqladmin: connect to server at 'breguet' failed error: 'Host 'breguet.experia.com' is not allowed to connect to this MySQL server' what can I do to solve this ?... I don't know i removed the things, and tried to install the 3.23.38 release instead, my the problem is not solved I've tried every thing to get connected, but nothing went right I could do a mysqladmin version, and the answer was correct, but no connection... So, I re-install the whole box (it's a test box...) in order to see if i was wrong somewhere, and where i could have messed things up but I'm curious to find an answer... Stephane - 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
installation
Hi everyone I'm back to the list... I have a slight problem... I have downloaded the 3.23.37 in rpm. I installed it on a SuSE 7.0 box. At the end of the RPM -Uvh, i had the message you should enter a password /usr/bin/mysqladmin... But after a quick look, I don't have any mysqladmin anywhere on the disk, and especially not on /usr/bin... anyone had the same problem ?... TIA Stephane Parenton - 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
[NEWBIE] Problem to launch mysqld
I try to execute "safe_mysqld --user=mysqladmin " and the system return: "chown: mysqladmin: usesager invalide Starting mydqld daemon with databases from var/lib/mysgl 010422 : 17:59:25 mysqld ended" I'm extremely newbie in Linux and I waould appreciate some help To launch MySQL PII 350 Mhz running Linux Redhad 7.0 distribution Thanks -- Stphane Pinel 39, Rue du Docteur Heulin 75017 Paris (FRANCE) 33 1 53 11 05 77 33 6 08 94 63 16 [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
[NEWBIE] safe_mysqld
When I attempt to launch mysql server with command safe_mysqld, the console return this: "starting mysqld daemon with databases from /var/lib/mysql" "010327 19:33:37 mysqld ended" I use RedHat 7.0 Linux on Intel -- Stphane Pinel 39, Rue du Docteur Heulin 75017 Paris (FRANCE) 33 1 53 11 05 77 33 6 08 94 63 16 [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
Re: [NEWBIE] safe_mysqld
on 27/03/01 21:42, Rick Emery at [EMAIL PROTECTED] wrote: I had the same problem. Ensure that /var, /var/lib, and /var/lib/mysql have their permissions set to: drwxr-xr-x /var/lib/mysql hasn't these permissions but now, it's OK. But I still have the same answer: "starting mysqld daemon with databases from /var/lib/mysql" "010327 23:11:20 mysqld ended" I saw that even the owner of /var /var/lib is 'root', the owner of /var/lib/mysql is 'mysql'. Is it right ? Thanks for your help. Stephane -Original Message- From: Stephane Pinel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 12:58 PM To: [EMAIL PROTECTED] Subject: [NEWBIE] safe_mysqld When I attempt to launch mysql server with command safe_mysqld, the console return this: "starting mysqld daemon with databases from /var/lib/mysql" "010327 19:33:37 mysqld ended" I use RedHat 7.0 Linux on Intel -- Stphane Pinel 39, Rue du Docteur Heulin 75017 Paris (FRANCE) 33 1 53 11 05 77 33 6 08 94 63 16 [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
Access from anywhere to a hosted MySQL Database
I would like to know If there are webhosters that accept connections to hosted MySQL databases from other domains than localhost (via php) ? I want to manage MySQL database directly from anywhere with home-made tools. Thanks -- -- Stphane Pinel 39, Rue du Docteur Heulin 75017 Paris (FRANCE) +33 1 53 11 05 77 +33 6 08 94 63 16 [EMAIL PROTECTED] http://spinel.anotherlight.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
