Edwin Limachi está ausente de la oficina.
Estaré ausente de la oficina desde el 28/02/2005 y no volveré hasta el 04/03/2005. Podré atender sus mensajes únicamente al final de la tarde. Para emergencias envie un mensaje a mi teléfono celular. Agradezco su comprensión. Exito para el Nuevo Año. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Edwin Limachi está ausente de la oficina.
Estaré ausente de la oficina desde el 27/12/2004 y no volveré hasta el 03/01/2005. Responderé a su mensajes a mi retorno. Exito para el Nuevo Año. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ENCRYPT() function
Dear list: I have a short database with id,username and password for authenticate my users with freeradius. The passwords are encrypted through ENCRYPT() function. I´d like to know why ENCRYPT() function doesn´t give the same encrypted string for a clear text string?. e.g. In the first time ENCRYPT('cisco123') gives HynlnFeaQzLzU In the second time ENCRYPT('cisco123') gives IydYEKE4Pk85s In the third time ENCRYPT('cisco123') gives KyJV8FPCwndcc I´m writing a script with php+mysql for change these passwords, for that the user have to type its actual password, so the php script must to match with the password stores into DB. Before the match this password, my script encrypts it with the same function, but it never will be the same, so it won´t match. I have to use ENCRYT() because freeradius only works with it. Do you know other method for it? Thank you. EDWIN LIMACHI N. Phone. 591-2-2123978 Movil: 591-715-29967 Fax: 591-2-2123975 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ENCRYPT() function
Thank you very much Paul. EDWIN LIMACHI N. Phone. 591-2-2123978 Movil: 591-715-29967 Fax: 591-2-2123975 Paul DuBois [EMAIL PROTECTED] 21/10/2004 15:56 Para [EMAIL PROTECTED], [EMAIL PROTECTED] cc Asunto Re: ENCRYPT() function At 15:41 -0400 10/21/04, [EMAIL PROTECTED] wrote: Dear list: I have a short database with id,username and password for authenticate my users with freeradius. The passwords are encrypted through ENCRYPT() function. I´d like to know why ENCRYPT() function doesn´t give the same encrypted string for a clear text string?. e.g. In the first time ENCRYPT('cisco123') gives HynlnFeaQzLzU In the second time ENCRYPT('cisco123') gives IydYEKE4Pk85s In the third time ENCRYPT('cisco123') gives KyJV8FPCwndcc If you don't supply the second (salt) argument, the result can vary over time for a given first argument. To get the same value each time, supply a constant salt argument. I´m writing a script with php+mysql for change these passwords, for that the user have to type its actual password, so the php script must to match with the password stores into DB. Before the match this password, my script encrypts it with the same function, but it never will be the same, so it won´t match. I have to use ENCRYT() because freeradius only works with it. Do you know other method for it? -- 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]
Mysql Query Browser is not launch
Dear list. I´m trying to work with Mysql-Query Browser Application. So, I installed it following the manual instructions but when I try to run it cannot be launched. Into the ./mysql-query-browser/bin directory I type mysql-query-browser and I receive this error message: bash:mysql-query-browser: command not found I tried too from RUN tab from GNOME task bar and the problem is the same. Excuse me if this ask is stupid. Any suggestions? Thank you. EDWIN LIMACHI N. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How can I dump and empty a table?
Dear list: I apologize post this question, but I`m newbie with MySQL. I have a database called tacacs, it has many tables and one of them is called accounting. This table has many data stored since 2 month ago and it is very big and it increases frequently everyday. I`d like to know how can I dump (backup) the data from this table and left it empty periodically, because I have to do some queries from a Web UI? I`ll be very greateful if someone could give me some suggestions with this issue? Thank you, EDWIN LIMACHI N. DATACOM - Instalaciones Phone. 591-2-2123978 Movil: 591-715-29967 Fax: 591-2-2123975 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How can I dump and empty a table?
Hi Vaso: I tried with your suggestion, it works fine. I have the backup now. I have two questions: How can I erase the actual data from my table? and How can I restore them from my backup file? Thank you and best regards, EDWIN Vasoczki Ferenc [EMAIL PROTECTED] 09/12/2003 12:28 Para [EMAIL PROTECTED] cc Asunto RE: How can I dump and empty a table? Lets do this: mysqldump -u user -p [database_name] [tablename] ./thefilewhatyouwouldliketocreate.dmp Check that file. VAso -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 5:25 PM To: [EMAIL PROTECTED] Subject: How can I dump and empty a table? Dear list: I apologize post this question, but I`m newbie with MySQL. I have a database called tacacs, it has many tables and one of them is called accounting. This table has many data stored since 2 month ago and it is very big and it increases frequently everyday. I`d like to know how can I dump (backup) the data from this table and left it empty periodically, because I have to do some queries from a Web UI? I`ll be very greateful if someone could give me some suggestions with this issue? Thank you, EDWIN LIMACHI N. DATACOM - Instalaciones Phone. 591-2-2123978 Movil: 591-715-29967 Fax: 591-2-2123975 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to pass syslog data to a MySql Database?
Dear list: I`m running a syslogd into my Linux box for logging all event send from our Cisco routers, these event are logged in text format, for instance: Dec 3 15:01:36 sin-trj 8351: Dec 3 15:01:35.322 BO: %SNMP-3-AUTHFAIL:Authentication failure for SNMP req from host 10.1.10.12 Dec 3 15:01:38 sin-trj 8352: Dec 3 15:01:37.318 BO: %SNMP-3-AUTHFAIL:Authentication failure for SNMP req from host 10.1.10.12 Dec 3 15:01:40 sin-trj 8353: Dec 3 15:01:39.318 BO: %SNMP-3-AUTHFAIL:Authentication failure for SNMP req from host 10.1.10.12 Dec 3 15:01:42 sin-tnd 8286: Dec 3 15:01:41.328 BO: %SNMP-3-AUTHFAIL:Authentication failure for SNMP req from host 10.1.10.12 Dec 3 15:01:42 nas-cbb-gisuq 10124: Dec 3 15:01:41.818 BO:%PQUICC-1-LOSTCARR: Unit 0, lost carrier. Transceiver problem? Dec 3 15:01:44 sin-tnd 8287: Dec 3 15:01:43.324 BO: %SNMP-3-AUTHFAIL:Authentication failure for SNMP req from host 10.1.10.12 Dec 3 15:01:46 sin-tnd 8288: Dec 3 15:01:45.324 BO: %SNMP-3-AUTHFAIL:Authentication failure for SNMP req from host 10.1.10.12 Dec 3 15:01:48 sin-tnd 8289: Dec 3 15:01:47.324 BO: %SNMP-3-AUTHFAIL:Authentication failure for SNMP req from host 10.1.10.12 Dec 3 15:01:50 sin-tnd 8290: Dec 3 15:01:49.320 BO: %SNMP-3-AUTHFAIL:Authentication failure for SNMP req from host 10.1.10.12 Dec 3 15:01:52 172.30.1.49 8234: Dec 3 15:01:51.601 BO: %SNMP-3-AUTHFAIL:Authentication failure for SNMP req from host 10.1.10.12 Dec 3 15:01:54 172.30.1.49 8235: Dec 3 15:01:53.597 BO: %SNMP-3-AUTHFAIL:Authentication failure for SNMP req from host 10.1.10.12 Dec 3 15:01:56 172.30.1.49 8236: Dec 3 15:01:55.589 BO: %SNMP-3-AUTHFAIL:Authentication failure for SNMP req from host 10.1.10.12 Dec 3 15:01:58 172.30.1.49 8237: Dec 3 15:01:57.597 BO: %SNMP-3-AUTHFAIL:Authentication failure for SNMP req from host 10.1.10.12 Dec 3 15:02:00 172.30.1.49 8238: Dec 3 15:01:59.589 BO: %SNMP-3-AUTHFAIL:Authentication failure for SNMP req from host 10.1.10.12 I`d like to get some suggestion over how can I to load these text file to a MySql database automatically. Thank you for your help. EDWIN LIMACHI N. DATACOM - Instalaciones Phone. 591-2-2123978 Movil: 591-715-29967 Fax: 591-2-2123975 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ENCRYPT Syntax problem
Dear list: I`m trying to insert some values into my table but I received a error message when I type:: INSERT INTO TABLE admin VALUES ('admin',ENCRYPT('system'),15,0); The error said: Error 1064: You have an error in SQL syntax. Could someone help me to clarify the correct syntax for ENCRYPT function, please? Thank you. EDWIN LIMACHI N. DATACOM - Instalaciones TSE - INFONET BOLIVIA Phone. 591-2-2123978 Movil: 591-715-29967 Fax: 591-2-2123975
RE: /etc/my.cnf config file doesn`t exist on my system
Hi Jamie: Thank very much you for your help. EDWIN LIMACHI N. DATACOM - Instalaciones TSE - INFONET BOLIVIA Phone. 591-2-2123978 Movil: 591-715-29967 Fax: 591-2-2123975 James M Kupernik [EMAIL PROTECTED] 17/09/2003 21:01 Por favor, responda a [EMAIL PROTECTED] Para [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] cc Asunto RE: /etc/my.cnf config file doesn`t exist on my system you just need to restart mysql now as long as you put the file into /etc/my.cnf shutdown mysql: mysqladmin -u root -p shutdown start: safe_mysqld The file never installed from me from the RPM either, i had to manually copy it in, yet the server will work without it. Hope that helps. Jamie -Original Message- From: James M Kupernik [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:35 PM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: RE: /etc/my.cnf config file doesn`t exist on my system Look in /usr/share/doc/packages/MySQL-server/ for some example my.cnf and find the one that works for you and copy it the /etc Jamie -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:17 PM To: [EMAIL PROTECTED] Subject: /etc/my.cnf config file doesn`t exist on my system Importance: High Dear list: I`ve just to install the binary RPM MySQL-serverv 4.0.15 into my Linux RH7.3 box. The installation was successfull however when I tried to edit the /etc/my.cnf file to configure error and query path logs, my Linux system says : /etc/cnf: No such file or directory However when I runn rpm -ql MySQL-server I see this output: /etc/init.d/mysql /etc/logrotate.d/mysql /etc/my.cnf /usr/bin/isamchk /usr/bin/isamlog /usr/bin/my_print_defaults /usr/bin/myisamchk /usr/bin/myisamlog /usr/bin/myisampack /usr/bin/mysql_convert_table_format /usr/bin/mysql_explain_log /usr/bin/mysql_fix_extensions /usr/bin/mysql_fix_privilege_tables /usr/bin/mysql_install_db /usr/bin/mysql_secure_installation /usr/bin/mysql_setpermission /usr/bin/mysql_zap /usr/bin/mysqlbug /usr/bin/mysqld_multi /usr/bin/mysqld_safe /usr/bin/mysqlhotcopy /usr/bin/mysqltest /usr/bin/pack_isam /usr/bin/perror /usr/bin/replace /usr/bin/resolve_stack_dump /usr/bin/resolveip /usr/bin/safe_mysqld /usr/lib/mysql/mysqld.sym /usr/sbin/mysqld /usr/sbin/rcmysql the rest was ommited for me I reinstalled the RPM packet but the problem exist still. What should I do? Some one have any suggestions? EDWIN LIMACHI N. DATACOM - Instalaciones TSE - INFONET BOLIVIA Phone. 591-2-2123978 Movil: 591-715-29967 Fax: 591-2-2123975 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
/etc/my.cnf config file doesn`t exist on my system
Dear list: I`ve just to install the binary RPM MySQL-serverv 4.0.15 into my Linux RH7.3 box. The installation was successfull however when I tried to edit the /etc/my.cnf file to configure error and query path logs, my Linux system says : /etc/cnf: No such file or directory However when I runn rpm -ql MySQL-server I see this output: /etc/init.d/mysql /etc/logrotate.d/mysql /etc/my.cnf /usr/bin/isamchk /usr/bin/isamlog /usr/bin/my_print_defaults /usr/bin/myisamchk /usr/bin/myisamlog /usr/bin/myisampack /usr/bin/mysql_convert_table_format /usr/bin/mysql_explain_log /usr/bin/mysql_fix_extensions /usr/bin/mysql_fix_privilege_tables /usr/bin/mysql_install_db /usr/bin/mysql_secure_installation /usr/bin/mysql_setpermission /usr/bin/mysql_zap /usr/bin/mysqlbug /usr/bin/mysqld_multi /usr/bin/mysqld_safe /usr/bin/mysqlhotcopy /usr/bin/mysqltest /usr/bin/pack_isam /usr/bin/perror /usr/bin/replace /usr/bin/resolve_stack_dump /usr/bin/resolveip /usr/bin/safe_mysqld /usr/lib/mysql/mysqld.sym /usr/sbin/mysqld /usr/sbin/rcmysql the rest was ommited for me I reinstalled the RPM packet but the problem exist still. What should I do? Some one have any suggestions? EDWIN LIMACHI N. DATACOM - Instalaciones TSE - INFONET BOLIVIA Phone. 591-2-2123978 Movil: 591-715-29967 Fax: 591-2-2123975
How to recovery the root password?
Dear List. This morning we made some changes in the user field of the mysql database, we changes the root password there, after that we can not get access to our mysql server with the new root password and with the old password neither. How can we do? Is there any procedures for recovery the password or to access to the server in this case? Thank you for your help. EDWIN LIMACHI N. DATACOM - Instalaciones TSE - INFONET BOLIVIA Phone. 591-2-2123978 Movil: 591-715-29967 Fax: 591-2-2123975
Re: How to enable General Query_log?
Dear Miguel: Firstly I found the path for mysqld, in my system (Linux RH7.3), it is in /usr/libexec/ Then I write this command: /usr/libexec/mysqld --log=/var/mysqldquery.log -u root however the system give me this message: bash: mysqld: command not found I don`t understand what is happen. Could you help me with this issue, please? I`d like to get the mysql error logs and query logs. Thank you, Edwin Limachi N. DATACOM - Instalaciones La Paz Tel.: 591-2-212-3978 Cel.: 591-715-29967 Fax.: 591-2-212-3975 miguel solorzano [EMAIL PROTECTED] 10/09/2003 20:11 Para [EMAIL PROTECTED], [EMAIL PROTECTED] cc Asunto Re: How to enable General Query_log? At 17:07 10/9/2003 -0400, [EMAIL PROTECTED] wrote: Hi, Notice the option syntax --log: /usr/local/mysql/libexec/mysqld --log=/usr/local/mysql/var/mysqlquery.log -uroot 030910 20:03:54 InnoDB: Started /usr/local/mysql/libexec/mysqld: ready for connections. Version: '4.0.15-debug-log' socket: '/tmp/mysql.sock' port: 3306 # tail /usr/local/mysql/var/mysqlquery.log /usr/local/mysql/libexec/mysqld, Version: 4.0.15-debug-log, started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id CommandArgument 030910 20:07:05 1 Connect [EMAIL PROTECTED] on 030910 20:07:17 1 Query select version() Dear list friends: I`d like to get your help about this issue. I have a Linux box RedHat 7.3 running the MySQL v3.23.56. In this box I`m running a TACACS server for authenticating my users to access to cisco routers. TACACS is using a Mysql database where i configured the user accounts, however TACACS can not get this info from this data base. I`d like to see the query log for the MySQL. The manual says that for it we have to start mysql with a query log. I typed: shell#mysqld - - log[=/var/log/mysqlquery.log] but I get this message: bash: myslqd command not found What is the correct syntax and where have I to write it for start mysql with a query log? Thank you for your help, -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil
Re: How to enable General Query_log?
Dear Mohamed: I tried with your suggestion but when I like to see the /var/ mysql_query.log file my system says that this file doesn`t exist. What can I do? Thank you, Edwin Limachi N. DATACOM - Instalaciones La Paz Tel.: 591-2-212-3978 Cel.: 591-715-29967 Fax.: 591-2-212-3975 Mohamed Lrhazi [EMAIL PROTECTED] 11/09/2003 08:19 Para [EMAIL PROTECTED] cc Asunto Re: How to enable General Query_log? Edit /etc/my.cnf add the line for log to the mysqld section log=/var/log/mysql_query.log or whetever... then run: /etc/init.d/mysqld restart Mohamed~ On Wed, 2003-09-10 at 17:07, [EMAIL PROTECTED] wrote: Dear list friends: I`d like to get your help about this issue. I have a Linux box RedHat 7.3 running the MySQL v3.23.56. In this box I`m running a TACACS server for authenticating my users to access to cisco routers. TACACS is using a Mysql database where i configured the user accounts, however TACACS can not get this info from this data base. I`d like to see the query log for the MySQL. The manual says that for it we have to start mysql with a query log. I typed: shell#mysqld - - log[=/var/log/mysqlquery.log] but I get this message: bash: myslqd command not found What is the correct syntax and where have I to write it for start mysql with a query log? Thank you for your help,
Re: How to enable General Query_log?
Dear Kelley: We tryed with your suggestion, thank you very much. We can see the mysqlupdate and 20030911.mysqldump files. However when we connect an do some queries to our Mysql server, we can not see anything, the columns Time, Id Command and Argument are in blank. Is there something additional variables that we have to configure ? Thank you for your support, EDWIN LIMACHI N. DATACOM - Instalaciones TSE - INFONET BOLIVIA Phone. 591-2-2123978 Movil: 591-715-29967 Fax: 591-2-2123975 Kelley Lingerfelt [EMAIL PROTECTED] 11/09/2003 12:39 Para [EMAIL PROTECTED], [EMAIL PROTECTED] cc Asunto Re: How to enable General Query_log? I haven't used 9.0, I'm using 7.3, but I suspect it should be very similar, as root, edit the /etc/my.cnf file and add a couple of lines to the top section: it should look similar to this [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log=/var/log/mysql/mysqllog log-update=/var/log/mysql/mysqlupdate the two log etries probably aren't there, add them and save the file then run these commands: cd /var/log mkdir mysql chown mysql.mysql mysql chmod 700 mysql then you should be able to restart the mysql server with this command service mysql restart this should restart the server and then the logs should be filling up with all the queries and most importantly the update log will record all the actual changes that occur in the database, so you can reconstruct it from a known point, or revert back from a backup and bring the database back to a point where something bad happened, human or machine wise.. :) and then when you have this running, you probably should run the mysqldump program from the command line, and use the mysqldump --opt --flush-logs --all-databases 20030911.mysqldump.sql and that should give you a good backup from right now and the update log files will be restarted from this point in time.. Kelley [EMAIL PROTECTED] wrote: Dear Miguel: Firstly I found the path for mysqld, in my system (Linux RH7.3), it is in /usr/libexec/ Then I write this command: /usr/libexec/mysqld --log=/var/mysqldquery.log -u root however the system give me this message: bash: mysqld: command not found I don`t understand what is happen. Could you help me with this issue, please? I`d like to get the mysql error logs and query logs. Thank you, Edwin Limachi N. DATACOM - Instalaciones La Paz Tel.: 591-2-212-3978 Cel.: 591-715-29967 Fax.: 591-2-212-3975 miguel solorzano [EMAIL PROTECTED] 10/09/2003 20:11 Para [EMAIL PROTECTED], [EMAIL PROTECTED] cc Asunto Re: How to enable General Query_log? At 17:07 10/9/2003 -0400, [EMAIL PROTECTED] wrote: Hi, Notice the option syntax --log: /usr/local/mysql/libexec/mysqld --log=/usr/local/mysql/var/mysqlquery.log -uroot 030910 20:03:54 InnoDB: Started /usr/local/mysql/libexec/mysqld: ready for connections. Version: '4.0.15-debug-log' socket: '/tmp/mysql.sock' port: 3306 # tail /usr/local/mysql/var/mysqlquery.log /usr/local/mysql/libexec/mysqld, Version: 4.0.15-debug-log, started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id CommandArgument 030910 20:07:05 1 Connect [EMAIL PROTECTED] on 030910 20:07:17 1 Query select version() Dear list friends: I`d like to get your help about this issue. I have a Linux box RedHat 7.3 running the MySQL v3.23.56. In this box I`m running a TACACS server for authenticating my users to access to cisco routers. TACACS is using a Mysql database where i configured the user accounts, however TACACS can not get this info from this data base. I`d like to see the query log for the MySQL. The manual says that for it we have to start mysql with a query log. I typed: shell#mysqld - - log[=/var/log/mysqlquery.log] but I get this message: bash: myslqd command not found What is the correct syntax and where have I to write it for start mysql with a query log? Thank you for your help, -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
How to enable General Query_log?
Dear list friends: I`d like to get your help about this issue. I have a Linux box RedHat 7.3 running the MySQL v3.23.56. In this box I`m running a TACACS server for authenticating my users to access to cisco routers. TACACS is using a Mysql database where i configured the user accounts, however TACACS can not get this info from this data base. I`d like to see the query log for the MySQL. The manual says that for it we have to start mysql with a query log. I typed: shell#mysqld - - log[=/var/log/mysqlquery.log] but I get this message: bash: myslqd command not found What is the correct syntax and where have I to write it for start mysql with a query log? Thank you for your help, EDWIN LIMACHI N. DATACOM - Instalaciones TSE - INFONET BOLIVIA Phone. 591-2-2123978 Movil: 591-715-29967 Fax: 591-2-2123975
How to enable General Query_log?
Dear list friends: I`d like to get your help about this issue. I have a Linux box RedHat 7.3 running the MySQL v3.23.56. In this box I`m running a TACACS server for authenticating my users to access to cisco routers. TACACS is using a Mysql database where i configured the user accounts, however TACACS can not get this info from this data base. I`d like to see the query log for the MySQL. The manual says that for it we have to start mysql with a query log. I typed: shell#mysqld - - log[=/var/log/mysqlquery.log] but I get this message: bash: myslqd command not found What is the correct syntax and where have I to write it for start mysql with a query log? Thank you for your help, EDWIN LIMACHI N.
How to enable General Query_log?
Dear list friends: I`d like to get your help about this issue. I have a Linux box RedHat 7.3 running the MySQL v3.23.56. In this box I`m running a TACACS server for authenticating my users to access to cisco routers. TACACS is using a Mysql database where i configured the user accounts, however TACACS can not get this info from this data base. I`d like to see the query log for the MySQL. The manual says that for it we have to start mysql with a query log. I typed: shell#mysqld - - log[=/var/log/mysqlquery.log] but I get this message: bash: myslqd command not found What is the correct syntax and where have I to write it for start mysql with a query log? Thank you for your help, EDWIN LIMACHI N. DATACOM - Instalaciones TSE - INFONET BOLIVIA Phone. 591-2-2123978 Movil: 591-715-29967 Fax: 591-2-2123975
How to enable General Query_log?
Dear list friends: I`d like to get your help about this issue. I have a Linux box RedHat 7.3 running the MySQL v3.23.56. In this box I`m running a TACACS server for authenticating my users to access to cisco routers. TACACS is using a Mysql database where i configured the user accounts, however TACACS can not get this info from this data base. I`d like to see the query log for the MySQL. The manual says that for it we have to start mysql with a query log. I typed: shell#mysqld - - log[=/var/log/mysqlquery.log] but I get this message: bash: myslqd command not found What is the correct syntax and where have I to write it for start mysql with a query log? Thank you for your help,
How to enable General Query_log?
Dear list friends: I`d like to get your help about this issue. I have a Linux box RedHat 7.3 running the MySQL v3.23.56. In this box I`m running a TACACS server for authenticating my users to access to cisco routers. TACACS is using a Mysql database where i configured the user accounts, however TACACS can not get this info from this data base. I`d like to see the query log for the MySQL. The manual says that for it we have to start mysql with a query log. I typed: shell#mysqld - - log[=/var/log/mysqlquery.log] but I get this message: bash: myslqd command not found What is the correct syntax and where have I to write it for start mysql with a query log? Thank you for your help,