How Do I Enable Query Logging? Is It Secure?
How do I enable query logging? I am using version 4.1.22-standard
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.
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.
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.
Can't Turn On Slow Query Logging
long_query_time = 1 log-slow-queries = /var/lib/mysql/slow_queries.log Is the above syntax not correct for enabling slow query logging? All examples I've seen have the dashes in the second variable and underscores in the first. When I restart MySQL with those lines in my.cnf, it fails to start, but writes nothing to its error log. /var/lib/mysql/slow_queries.log exists, is owned by mysql, and has read/write permission.
Turning On Slow Query Logging?
Background: I paid a young admin set me up on a database server. He installed the basic I needed for the server...at my request...No Cpanel...mysql and apache and some tight security w/o even a domain name to SSH into. Unfortunately, he's a busy kid, and teens sometimes don't realize that people depend on them...and well, I can't really seem to get him to do much so I gave up and figured it's a good way to force me to learn all this myself... Well anyway, now I want to turn on Slow Query logging. But before I do that, I need to know how MySQL is running. Is SQLogging turned on already? Where is it logging to? So first thing I want to look up is, when the server is rebooted, what's the command to restart mysql? No clue. How do I change the setting? And of course, the server is production, so when I make the change, it needs to be quick, it needs to be smooth, and I need to be able to roll back to the previous config if necessary. I'm running Redhat Enterprise.
Switch Query Logging While The Server Is Running
It would be nice if general query logging could be switched on and off while the MySQL server is running, and not only at startup time. While debugging an application that uses foreign database access libraries, this would be very helpful. One could switch on logging, perform an activity, switch off logging, and look what has happened. Otherwise, the server has to be restarted to change logging, which is a bit annoying...
Non Networked = Non Secure
mySQL looks good for a Network. BUT as a standalone it is not secure.Open anytable.MYD in a hex editor and you can see the data.So we can't sell our software to clients on wind98. Believe it or not we have had a lot of success selling software with a proprietary database where the data is in 'unusual' format. Clients are happy because casual snoopers can't see personal data,and we dont promise "strong" security. Security through obscurity works!I wish mySQL had even a touch of obscurity in its MYD files.
Replication Secure
I'm about to jump into the world of mysql replication, but am wondering if the connection between database servers is secure seeing as how they will have to communicate across the internet.
Transaction Secure Code
When executing a specific query, I need to lock the db to ensure that no data is altered while the query executes. My question is: Do I need to take a ROLLBACK on the db to release the lock, or is it enought just to set autocommit=1 again? Simplified example of how I do it now: SET AUTOCOMMIT=0 BEGIN SELECT .......bla bla bla <execute some php code based on the result> ROLLBACK SET AUTOCOMMIT=1 Example of how I want it to be: SET AUTOCOMMIT=0 BEGIN SELECT .......bla bla bla <execute some php code based on the result> SET AUTOCOMMIT=1 Are there any downsides by not using ROLLBACK in the second example? The database has not been altered in any way.
How To Secure My Mysql Database From Others?
1) if somebody else knows my mysql database username and password ( username with all permissions ) can they copy my database even if they do not know my control panel password? 2) Suppose I have placed my database username and password in a .php file in my file manager not in the admin folder, is there any possibility for others to steal my username and password? 3) what steps should I take to secure my mysql database from hacking and all such unwanted dangers.
Designing A Secure Database?
I'm working on a website/database deal, and right now I'm designing the security model. It's using LAMP(HP), so all the tricks are going to be through PHP. First off, this will be behind a firewall with SSL encryption. We may also setup some kind of VPN tunneling.I'll be ignoring other security details that don't apply to the problem at hand, but please feel free to suggest. I'm going to have users enter a username and password, with PHP emulating the htaccess dialogue boxes. I would like to check the entered values in a permissions table. This table looks like: username | passwordhash | ipaddress | permission All users will have a static IP, so they have to match the username-password-ipaddress combination. I'm storing the passwords as an MD5 hash in case someone breaks in and reads the table. So what MySQL user does PHP log onto as the database as, in order to read the permissions table? (After that, we just go with the logged user's permission). If I make a special user that just has permission to read the permission table, do I have to store that user's password plaintext in a php script somewhere, thus adding a security risk if someone were to get a hold of that password?
Making Secure Database
how would i go about making my database as secure as possible so users information is kept as safe as possible.... at moment i am using md5 encryption for their passwords... does any1 recommend anything else ?? and also in general to keep my data as safe as possible..... will web hosts deal with keeping mysql database secure or should i do sumting against it?
Secure Backup On Win32 Systems?
mostly for unix platforms. On win32, what is the best way to run a secure mysqldump so that my password doesn't have to live in a script somewhere? I'm using perl scripts to kick off my backup commands.
From Test Environment To Secure Commercial Use.
I'm relatively new in the database administration field. Uptil now I've only tried MySQL together with PHP in a test environment. I would appreciate if someone could answer a couple of question, I have regarding commercial use and a secure professional configuration. Uptil now I've used XAMPP as my installation on my own computer on localhost. Now we'll install the same software package on a server. I guess XAMPP and PHPmyAdmin is not a professional setup right? Questions: 1. What is the best recommended and professional setup for commercial use? 2. What is the best GUI for the database? 3. What is Frontend and Backend? 4. Backup setup? Just if anyone have some recomendation. I've built a web based dynamic Content Management System in PHP and MySQL for internal use. Using the localhost as the developer platform. I've never before built something like this for commercial use. 5. How do best implement this system on our companys server, so we all can use the system?
Secure Backup On Win32 Systems?
i know items have been posted before, mostly for unix platforms. On win32, what is the best way to run a secure mysqldump so that my password doesn't have to live in a script somewhere? I'm using perl scripts to kick off my backup commands.
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 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.
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.
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?
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 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?
Logging Problem
I have a problem with mysql general log, regarding query logging. I'm running Win2K, mysql 4.1.10 with JBoss 4.0.2. When I turn on logging, the statements executed from JBoss and logged by mysql look like this: SELECT uuid from tablex AS a WHERE a.id = ?; MySQL never logs the parameters of the statements. Can somebody tell me how to turn this on or what I am missing here?
Logging Into Server
I have a linux box with MySQL. The following fails. If I try to login locally using mysql -u USERNAME -p If I go to another computer on the network and try using the same user name and password by: mysql -h SERVER ADDRESS -u USERNAME -p This login is successful. Does anyone know why the first operation fails?
Logging With Trigger
I am designing a chatsystem with logging-functionality. And i want to handle the logging-stuff within a trigger. As a procedure the code works, so the syntax in ok. As a trigger i get no errors but nothing is logged. create trigger messages_insert before insert on messages for each row begin declare a tinyint(1) unsigned; select logging into a from users where id = 1; if a = 1 then insert into logfile set content = 'A'; end if; end
|
TRACKER
