Enable Mysql Logging
how common it is for production websites (sites that get used frequently) such as small online stores etc, to enable logging on the database end. Is it that common ? Seems like it might be a performance hit and maybe it might be a good idea only if one suspected something wasnt right (cyber attacks). Any php / mysql errors will be hopefully caught and logged by other means, so the only reason i see to log database action is for seeing just who is trying to get access.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
How Do I Enable Logging?
I need to enable MySQL logging. I looked in the my.ini file and did not see any logging options. Where do I turn on logging? I am using Windows.
How Do I Enable Binary Logging
I would like to enable binary logging on my database.Am using winXP The information i have talks of adding some lines to my.cnf file then restarting mysql.
MySQL 3 - How To Enable Tcp/ip?
I think that in my mySql named pipes are enabled by default. I need to enable tcp/ip now. Can somebody give me strict instructions how to do this?
Enable Unicode In MySQL 4.1.0-alpha
I have read that Unicode (UTF-8) was not enabled by default in the mysql-4.1.0-alpha binaries. How can I enable it? What should I change in the code to do so?
Disable And Enable A Foreign Key In Mysql 5
i have created primary key / foreign keys...but then when I am trying to change the data later, i am getting error, now i want to disable the foreign key, change my data, and enable it again but i am unable to find the correct syntax for this.
IIS Logging To Mysql?
Can you setup mysql ODBC so that IIS can log into mysql? if so is there any good article/ instructions on the setup?
MySQL 5 Logging
I've installed MySQL Server 5.0 on Win2K IIS as well as PHP 5.0. PHP works fine, and so does MySQL...the problem is that I can't get the two to talk to each other
Logging On And Off MySQL
How does MySQL manage connections/sessions that are not formally and properly closed? What are the possible negative consequences if many of the software/operators on the client side fail to properly close the sessions they open? Will the MySQL server be able to handle this gracefully? Or will they consume server resources until the system crashes? Will the open sessions eventually time out close automatically? Is there a timeout value that can be set on the server? Can one query the server for information about open connections?
MySQL Logging Out
I'm not sure if this is related to MySQL or just happens to be occuring with MySQL on the Linux box, but MySQL will -- at random intervals -- log out without my explicit action and be followed by this message [X]+ Stopped mysql -u <user> -p <database> (where X is a number) Now I don't have admin or root access to this server, but is there anything I can do or talk about with the administrator?
Logging On To MySQL - Problem
I'm trying to log on to MySQL for the first time. I only installed MySQL and PHP for the first time yesterday. When I click on the mysql.exe (in C:Program FilesMySQLMySQL Server 5.0in) nothing happens. I thought I was meant to get a command prompt to type in my username and pw. The following actually happens to me: I double click on it, the command box opens for about 2 seconds and then closes down.
Mysql Logging Compiled In?
i'm trying to turn on mysql logging as follows, but it doesn't seem to work: mysqld --log=/root/log the logfile never shows up after a connection or query. so i want to know if logging support is compiled into mysql. i did not install it and i cannot ask the hoster. does anyone know how to check that? i don't even know where to begin.
Mysql Logging Compiled In?
i'm trying to turn on mysql logging as follows, but it doesn't seem to work: mysqld --log=/root/log the logfile never shows up after a connection or query. so i want to know if logging support is compiled into mysql. i did not install it and i cannot ask the hoster. does anyone know how to check that? i don't even know where to begin.
Logging Queries On MYSQL
I am running Red Hat and MySQL, I am needing to make it that mysql logs all queries done on the server, at the moment my /etc/my.cnf file looks like this. [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid What do I need to do to accompish this , I have looked on google and just cant find the answer at all to this.
MySql Change Logging
Is it possible for me to have the daily updation and insert queries performed on the MySQL DB saved? This will help me track when a particular record was modified in the DB. Is there any other way to track as to when the changes were made to the DB? I also want to add who made the changes but this will come at a later stage once the user login is implemented.
Logging MySql Statements
My server load goes up to 100 and I don´t know why. What I know, if I shot down the site, the server calms down and it works again. I have figured out that i have a mysql problem but I can t figure it out. Is it possible to log all MySql Statements which are running on my database ? If the server goes strange again I could check the log file for the problem.
Logging Using The Mysql Command
Unfortunately, I was experimenting and I changed the field Host in table User from localhost to %. Now I can no longer logon via the mysql -u root command. It wants to log on as root@localhost and I want to log on as root@%. How do I fix my mistake?
Can't Limit /var/log/mysql Logging
Mysql is filling my /var partition because the log limit doesn't seem to be respected. I've tried many different settings in /etc/mysql/my.cnf but nothing works. Logrotate is not enabled/configured. I just want mysql to use a maximum of, let's say, 1GB of my /var partition The log is /var/log/mysql/ Debian GNU/Linux 4.0 kernel 2.4.27-2-386 mysql version 5.0.30-Debian_1-log Following the /etc/mysql/my.cnf file Code:
Logging MySql Statements
My server load goes up to 100 and I don´t know why. What I know, if I shot down the site, the server calms down and it works again. I have figured out that i have a mysql problem but I can t figure it out. Is it possible to log all MySql Statements which are running on my database ? If the server goes strange again I could check the log file for the problem.
MySQL Logging And Encryption
If logging is turned on, is there a way to disable it for a given query? IE. If I query --> select AES_ENCRYPT("This is very important data", "lessthansecretkey"); Then my key and the value I'm trying to encrypt is visible in the log files.
Disable MySQL Logging
I was a bit surprised, when I saw that mySQL create a huge logs, entierly useless for my testing server purpose and since the machine is relatively (a lot, VIA C is nowhere near fast) slow, I looking for ways how to completely disable these unnecessary logging It is a Win2k server with mySQL 4.1.15-nt :-) PS. how to convince the service to use as default latin2 coding? --default-character-set=latin2_czech_ci Is mentioned into the guide, but the server did not accept it at all in properties and trying to set it into the ini file was undocumented and sometimes cause mySQL not to start + it still not working and use the damn utf8 crap, that kill the czech characters :(((
Mysql Logging Compiled In
i'm trying to turn on mysql logging as follows, but it doesn't seem to work: mysqld --log=/root/log the logfile never shows up after a connection or query. so i want to know if logging support is compiled into mysql. i did not install it and i cannot ask the hoster. does anyone know how to check that? i don't even know where to begin.
Logging Queries On Mysql With FreeBSD
I am trying to set up my mySQL server on FreeBSD to log every query a user runs. I understand I must edit the my.cnf file. But one does not exist for my install. I installed mySQL from the FreeBSD packages and for some reason, it did not create a my.cnf file in /etc or anywhere. Where can I set it up to log every query a user runs?
Trouble Logging Into MySQL Administrator
I've installed MySQL and it appears to running properly because I can enter data in the command line format but I'd like to use the graphical user interface of MySQL Administrator. When I try to log in, I can not get through. Is there someplace on the MySQL website that I can go to send me a reminder of the information I used to set-up the server and how to properly fill-out this form? When I hit contol and skip, it shows that my server is running. I did save the original information I gave on the website during the server configuration and download procedures but when I try different combinations of this information, I'm still not able to access the Administrator functions.
How Do I Turn On Logging To View Errors In MySQL 5
I'm a new MySQL user. Just switched over from the Bill Gates world and am joining the open source side finally. I setup a website using Joomla! 1.x with PHP5 and MySQL 5 on the backend. However when I submit a post in my forum on my new site, the page goes blank yet says it's finished loading. In the Microsoft world you can echo back to the screen errors and figure out which row, record or table was causing the error. Can you do the same using MySQL or does it have a logging feature that could help me troubleshoot and see why my posts are hanging when hitting the submit button via my browser?
Problem Logging In Using Mysql Password Function
I have a test server on a windows box with php 4.3.10 and mysql 4.1.10-nt. I built a login app and It works well using the mysql password('') function. Unfortunately I ported the app to a freebsd box running php 4.3.10 and mysql 4.1.12. The passwords come out differently and I don't understand why. For instance, the password test looks like "378b243e220ca493" on the windows box and the freebsd database entry look like "*94BDCEBE19083CE". As you can see, very different. And this causes a lockout from logging in. Instead of being routed to a "safe" login page, the error for a wrong username/password combo shows up.
Unchecking The Enable TCP/IP Option (was "Mysql Problem")
I have had a problem with Mysql so I downloaded it again but after configuring it would not start so reconfigured and unchecked the enable TCP/IP box in the networking options and Mysql worked fine. But can’t get PHP to connect so I think the enable TCP/IP box should be ticked. So I thought I would do better with a complete re start. I have removed and reloaded several times but the same problem occurs every time.
How Do I Start Logging On Windows Live MySQL Server?
As I understand it, the server has to be shut down for the logging to be successfully started. Is this correct? I have been experimenting on a local MySQL server to make sure I know what to do on the production server. My production server has a my.ini file at the location c:Program FilesMySQLMySQL Server 4.1my.ini with various config stuff in it. Would it be ok for me to add the following under the [mysqld] part of the file: log=/logs/mysqld.log Thus creating a file named 'mysqld.log' in the folder 'logs'. The main things I need to log are the SQL Statements being executed and the IP Addresses/hostname of the connections. What type of log would be best for this? Also how do I make it so that the log doesn't grow ridiculously large?
Enable Warnings
If I try to insert a value such as 123456 into a tinyint field, it will just insert the largest value that that field can contain. I'm wondering if there is a setting in MySQL that will trigger an error/warning when this occurs instead. Something like ANSI_WARNINGS in MsSql.
Enable SSL Feature
I'd like to launch a mysql server with SSL protocol enabled. I'm working on windows XP OS. I didn't find clear information about how to do that. In the user manual I can find in the 5.6.7.2 section that I have to launch an "@command{configure}" command with some options. The problem is : I can't find a "configure" command. The only thing I'm able to find is a shell script called "conf.sh" but I'm working on windows. Do I have to install cygwin or that kind of stuff ? I've read somewhere else that I had to compile mysql to be able to use it in SSL mode. I'm a bit lost with those informations.
Enable Pooling On My Sql
How do i enable pooling on mysql connection? this is my string. DRIVER={MySQL ODBC 3.51 Driver};" + "SERVER=dfdfd;" + "DATABASE=dbname;" + "UID=" + UserId +";" + "PASSWORD=ff;" + "OPTION=3
Enable InoDB Tables
I am running SuSE 9.0. I have installed, MySql 4.0.15. Apparantly versions 4.0 and above are supposed to come with InnoDB tables already enabled, this is not the case with mine, the have_innodb variable is at NO. I edit the my.cnf file to include the following as per mysql manual innodb_data_file_path = ibdata1:10M:autoextend set-variable = innodb_buffer_pool_size=70M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_log_file_size=20M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 However when I try and start mysqld up again I get error messages saying that all the variables are not recognised. These variables are mentioned again and again in help files to enable innodb tables in MySql.
How To Enable Mime Type
Sorry for another post but how do I enable mime types for my mysql installation. I have looked in the config file and I cannot find it.
Way To Enable Csv Engine In Mysql5.0.27
I want to find if there is any way to enable csv engine in mysql5.0.27.The manual says while configuring mysql use " --with-csv-storage-engine " but i'm not getting any idea from this.
Enable Remote Connections
When we connect to the database server on the same PC, we give the server as "localhost" When I tried to connect to the database on another PC by giving the hostname as server it gives the error as Access denied for user 'root'@'hostnmae' Can someone tell me how do I make sure remote connections are open for this mysql database and how can I identify it from another PC?
Failed To Enable Constraints
I have a desktop application in Visual Basic .NET working with a MySQL database. I got to populate the information from my database into the text fields on the form. I can navigate through the records (next, first, previous, last) BUT.. I can't get it to update the database. I am getting the following message: "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints" This is not a big table, it only has 8 fields (Name, lastname, address, city, zip, state, phonenumber) and the only non-null field that I am NOT INPUTTING manually on the form is the customerID(PK), which is supposed to be assigned automatically for mySql.
How To Enable Prefix Compression On MyISAM Indexes?
Anyone know? The manual suggests prefix compression (packing) is the default for all character type indexes, but "Packed" is always "NULL" in show indexes results... mysql> show indexes from _1_log; +--------+------------+-------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +--------+------------+-------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+ | _1_log | 0 | PRIMARY | 1 | ID | A | 27456 | NULL | NULL | | BTREE | | | _1_log | 1 | ip | 1 | ip | A | 3432 | NULL | NULL | YES | BTREE | | | _1_log | 1 | countryCode | 1 | uniqueVisit | A | 2 | NULL | NULL | YES | BTREE | | | _1_log | 1 | countryCode | 2 | countryCode | A | 188 | NULL | NULL | YES | BTREE | | | _1_log | 1 | language | 1 | uniqueVisit | A | 2 | NULL | NULL | YES | BTREE | | | _1_log | 1 | language | 2 | language | A | 85 | NULL | NULL | YES | BTREE | | | _1_log | 1 | browserFamily | 1 | uniqueVisit | A | 2 | NULL | NULL | YES | BTREE | | | _1_log | 1 | browserFamily | 2 | browserFamily | A | 42 | NULL | NULL | YES | BTREE | | | _1_log | 1 | browser | 1 | uniqueVisit | A | 2 | NULL | NULL | YES | BTREE | | | _1_log | 1 | browser | 2 | browserFamily | A | 42 | NULL | NULL | YES | BTREE | | | _1_log | 1 | browser | 3 | browserVersion | A | 76 | NULL | NULL | YES | BTREE | | | _1_log | 1 | os | 1 | uniqueVisit | A | 2 | NULL | NULL | YES | BTREE | | | _1_log | 1 | os | 2 | os | A | 25 | NULL | NULL | YES | BTREE | | | _1_log | 1 | resolution | 1 | uniqueVisit | A | 2 | NULL | NULL | YES | BTREE | | | _1_log | 1 | resolution | 2 | resolution | A | 83 | NULL | NULL | YES | BTREE | | | _1_log | 1 | depth | 1 | uniqueVisit | A | 2 | NULL | NULL | YES | BTREE | | | _1_log | 1 | depth | 2 | depth | A | 10 | NULL | NULL | YES | BTREE | | | _1_log | 1 | javascriptEnabled | 1 | uniqueVisit | A | 2 | NULL | NULL | YES | BTREE | | | _1_log | 1 | javascriptEnabled | 2 | javascriptEnabled | A | 4 | NULL | NULL | YES | BTREE | | | _1_log | 1 | searchEngine | 1 | uniqueVisit | A | 2 | NULL | NULL | YES | BTREE | | | _1_log | 1 | searchEngine | 2 | searchEngine | A | 13 | NULL | NULL | YES | BTREE | | | _1_log | 1 | uniqueVisit | 1 | uniqueVisit | A | 2 | NULL | NULL | YES | BTREE | | | _1_log | 1 | visitorId | 1 | visitorId | A | 5491 | NULL | NULL | YES | BTREE | | +--------+------------+-------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+ 23 rows in set (0.00 sec) This is MySQL 5.0.27.
Enable Root Access From Remote Machines?
I just setup MySQL5 on a Windows 2003 dedicated box and one of the last questions in the Instance Configuration Wizard had a check box labeled: "Enable Root Access From Remote Machines". I did some research but could not figure out what that meant. I log on to my box using Remote Desktop so if I don't check this will I able able to have root access? I am guessing this is a security issue. I want my box to be as safe as I can. Here is how I have the MySQL config file setup (from the Instance Configuration wizard): port=3306 basedir="C:/Program Files/MySQL/MySQL Server 5.0/" datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/" default-character-set=latin1 default-storage-engine=INNODB sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" max_connections=100 query_cache_size=49M table_cache=256 tmp_table_size=52M thread_cache_size=8 myisam_max_sort_file_size=100G myisam_max_extra_sort_file_size=100G myisam_sort_buffer_size=103M key_buffer_size=76M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size=256K innodb_data_home_dir="C:/MySQL Datafiles/" #skip-innodb innodb_additional_mem_pool_size=4M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=1524K innodb_buffer_pool_size=148M innodb_log_file_size=30M innodb_thread_concurrency=8
Logging In
I'm having trouble logging into my sql server, I'm running version 4.0 just about anything I type in gives me this error message "Error SQL query: mysql MySQL said: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql' at line 1 " Can anyone help me with this problem?
Logging
Is there a way to turn on some sort of logging? I am attempting to connect to a db through VB, just learned it and am not sure if I am getting in and not retrieving data or not even getting in yet. Can this be done through the console and then left on?
How Do I Set Query Logging
I have a situation where my database is deleting records. I would like to enable logging but this produces a huge text file. Also I am not sure how to read the results. I am using MySQL 3.23 (the IT department won't upgrade). Can anyone tell me the most efficient way to set logging for a specific database? I just need to monitor whether a process is deleting these records. Also how would I read this information? Are there any known problems like this with MySQL 3.23?
Query Logging?
I cannot get my query logging to work. I put log=hostname.log in my.ini and at some point it WAS recording a log, but it since stopped. I started the service, stopped the service, did everything. I logged into my machine as admin, as the user, did it all again... cant get it to work. I am running mysql 5 as part of the XAMPP stack. I installed it on this machine as admin and can run it as a service, but I cant get the log to work. Any help would be appreciated. I really need to see what SQL is being executed.
Logging On For The First Time
I've downloaded the XP Windows standard version, installed it and logged on without a problem. I've also downloaded the Linux standard version, installed it(Mandriva 2000 powerpack), and attempted to log on. However, I keep getting a message telling me that it can't find a socks in /var(whatever that is).
Logging In To Monitor Thru Dos
I am playing around with logging in and running commands through batch files on a win2000 machine running mysql, I have a password on my db, I am using mysql -h localhost -u root -p to start up the monitor this works, but it asks for a password which kind of kills the automated part of what I am wanting to do, is there a way to include the password on this command? I thought about passing the password using %1, but I haven't done dos in so long that I dont even know if this feature still works, does anybody?
|
TRACKER
