MYSQL :: Disable -- User Option

Joining User Option Lists
I have a niggly problem that I can't quite work out which I'm sure has a simple answer (have to be missing something).

I have a table of 7 categories, each with a unique ID and name.
A seperate table is a category/user mapping table which maps users to a category.

For example, if a user is a a member of 4/7 categories, they have 4 rows in the mapping table, each one with their userID/catID in it.

What I'm attempting to do is select a list of ALL categories and join (where applicable) the category map so I can present all options regardless of whether the user is a member of a particular category or not (but I do need to know if they are or not).

PHP

SELECT *
FROM categories
LEFT JOIN category_map ON categories.id = category_map.c_id
WHERE category_map.u_id=10

I had some success with adding OR category_map.u_id IS NULL but returns odd results when there are 0 rows present for a user in the category_map table.

Disable Log
I can disable bin logs

SET SQL_LOG_BIN=0;

But How do I disable and then enable the slow and general query log?

Disable Replication
I've got a server that used to use replication but no longer has any slaves. To turn this off and stop generating the bin files, do I just need to comment out the bin-log command in the cnf file then restart?

Disable A Trigger
I have found a need to disable a trigger for a short period of time while executing a query. Rather than delete the trigger and re-create it later, I wanna disable trigger for the tabe and after the execution enable the trigger.

Disable Bell
how to disable that annoying warning bell in the command line version of mysql. I am using mysql 5 on windows at the moment. I really don't appreciate the world knowing that mysql returned an error.

Disable A Single Database
Hi everyone I was wondering if there was a way to disable a single
database with having to shutdown mysql or rename tables?

Disable Privilege System
If I set skip-networking, what is the security risk if I also skip-grant-tables? Is there any performance benefit that might justify leaving the privilege system disabled?

This is a dedicated database that runs on the same machine that hosts the application that it supports.

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

How To Disable Binlog For Specific Table
For security reasons, we need a single table (containing sensible information) to be excluded from going to binlog. I have found out as much, that I can use SET SQL_LOG_BIN = {0|1} to switch logging on/off per connection, but I would prefer if I could simply exclude the table all together. The table is a ENGINE=MEMORY type table btw.

Enable/Disable (toggling) Triggers
I want to ENABLE/DISABLE my triggers time to time based upon certain conditions multiple times. How can I do that in MySQL ?

How To Disable Unused Table Types
I only use MyISAM for all my web applications, and that should suffice for years to come, so I'm wondering how to disable all other data types from the server, so it starts as only capable of dealing with MyISAM tables.

What other benefits there are in doing so, apart from perhaps a greater memory saving?

Sometime ago I thought of using/experiment with InnoDB type but it's initial 10MB footprint and all the changes in the existing code to make it transactional are too much perhaps. I also read somewhere InnoDB requires alot more memory than MyISAM, server only has 1GB.

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.

Disable Remote Root Login
I would like to keep root non password protected locally. And disable root login via phpmyadmin and other remote mamagement tools. For remote login I would have seperate users set up.

How To Disable Auto Truncation Of Char Binary Column
Why is a single space truncated in the following example?

Leif

alter table CURRENCY
change column THOUSANDS_SEP THOUSANDS_SEP char(1) binary not null
, type=MyISAM

UPDATE CURRENCY SET THOUSANDS_SEP = ' ' WHERE NAME = 'SEK'

SELECT LENGTH(THOUSANDS_SEP) AS L FROM CURRENCY WHERE NAME = 'SEK'
Result: L = 0

OPTION Value
Here's the connection string I use commonly with my VFP9 apps connecting to a MySQL5 backend:

DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;UID=mike;PWD=foxrocks;DATABASE=mydb;option=131609

I was wondering what other values for the OPTION parameter folks use? Sometimes, I get some flakiness, so I was searching for a consensus on "best option value to use."

Binary Log Off Option ?
I am using mysql version 4.0.22.
Which file to access and modify If i want to disable binary logs which are created in mysqlvar ?

Sql Option ALLOW_INVALID_DATES
how to implelent 'ALLOW_INVALID_DATES' option for sql mode?
I was able to run

SET GLOBAL sql_mode='ANSI';

but can't get the syntax of ALLOW_INVALID_DATES ...

Can't Set The Table Option
I've use the command CREATE TABLE as follow:

CREATE TABLE test(myid varchar(20)) DEFAULT CHARSET=latin1

and

CREATE TABLE test(myid varchar(20)) DEFAULT CHARACTER SET latin1

I've got an error message with the 2 commands above saying that I've used the wrong syntax near the "DEFAULT CHARSET=latin1" clause. I've read the MySQL Document and figured out those commands have the right syntax, not wrong.

Could anyone please tell me how to create a table with DEFAULT CHARSET=latin1.
( I have use MySQl ver 4.0 ).

Subselect In 4.0.12-max With -- New Option
I was reading the manual and it said that the subselect is only
available in 4.1 or using the 4.0.12 with the mysqld =96new command line
to start it.

But it doesn=92t working!! So I downloaded the 4.1 alpha version with =
the
same problem. The error is:

ERROR 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 =85.

Any ideas? I need subselect working.

Unknown Option -- Log-bin
Trying to use the mysql command-line client with a MySQL 5.0.21 database on Windows 2003 Server, and am getting the error message:

mysql: unknown option '--log-bin'

What does this mean and how can I get my command-line client back?

--force Option
I'm using a batch file to insert data into my database.
I read in the manual that using the --force option makes mysql to continue processing the batch file, although there was an error like "table does not exist" or something like that.

However I noticed that mysql still quits if it tries to insert data in a table that not exists.

I'm using mysql 5.0.19 under a windows xp system

the command i'm executing is as follows:

mysql -u root --force databasename < "path/to/batch.sql"

MySQL Replacement Option
I want to replace a character "/" with &frasl; in my database, is there any option to do that.

Local-infile Option
I´m using mysql 3.23.58 and I want to enable the local-infile option.
The manual on dev.mysql.com says the following to that:

.....
If you use LOAD DATA LOCAL in Perl scripts or other programs that read
the [client] group from option files, you can add the local-infile=1
option to that group. However, to keep this from causing problems for
programs that do not understand local-infile, specify it using the
loose- prefix:

[client]
loose-local-infile=1
......

But when I do that the I can restart the mysql-Server but starting of
mysqladmin says the following:

Unrecognized option local-infile

The same message with loose-local-infile=1.

When I start the server with --local-infile=1 and then starting the
mysql-Client with --local-infile=1 on the shell everything is OK and I
can use the LOAD DATA LOCAL Syntax.

What is wrong? Why it is an unregognized command? I need the LOAD DATA
LOCAL because I want to use mysql with Perl.

Error =SET OPTION SQL_BIG_SELECTS=1
I add a few more test records to my db.... the result the following error message...

Vbscript Runtime error 'ASP 0185 : 3219'

General error: The SELECT would examine too many records and probably take a very long time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=1 if the SELECT is ok

Well to the best of my knowledge my WHERE could not be more simple and all the tables concerned don't have that many records.

I've scanned the net but cannot find an obvious answer. Any clues... if I need to use "SET OPTION... how do I do this within ASP. Code:

Browse Option Not Shown?
However, some fields won't let me browse what are in the fields. I have full admin access tot the website. If any1 doesn't know what im talking about, I could post a screenshot, if nessessary.

Mysql --force Option
I'm using a batch file to insert data into my database.
I read in the manual that using the --force option makes mysql to continue processing the batch file, although there was an error like "table does not exist" or something like that.

However I noticed that mysql still quits if it tries to insert data in a table that not exists.

I'm using mysql 5.0.19 under a windows xp system

the command i'm executing is as follows:

mysql -u root --force databasename < "path/to/batch.sql"
Xema

Printing A Result After An Option Has Been Submitted
My goal is this.- To print another field value 'scriptcode', of the same row after an option 'scriptnaam' is submitted.

The first part isn't the problem. I do get all the data 'scriptnaam' in a select field.
But to distillate, a result 'scriptcode' out of it ???

If someone could help me a bit further with that, that would be great.
I like to mention, that I've just started with PHP/MYSQL, so my knowledge about it is limited. Code:

Mysql: Unknown Option '--ndbcluster'
Running into some issues while configuring my cluster....

I'm setting up a cluster with two storage nodes and one management node...
The problem I'm having is that when I try to open MySQL on one of the storage nodes I get this error...

mysql: unknown option '--ndbcluster'

but i do not get this error on the other storage node and i am able to access MySQL on it.

The my.cnf file looks like this:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysql_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

#Options for MySQLD process
[MYSQL]
ndbcluster #run ndb engine
ndb-connectstring=x.x.x.x #location of MGM node

#Options for ndbd process
[MYSQL_CLUSTER]
ndb-connectstring=x.x.x.x #location of MGM node

If anyone can let me know what the problem is it would be greatly appreciated...
I'm running Fedora Core 4 and MySQL 5.0.19 MAX

MySQL Performance - Option Setting
I set OPTION=3 in my connection string as recommended by MySQL
(http://dev.mysql.com/doc/refman/5.0...parameters.html)
for a VB application.

OPTION=3 is Don't Optimised Column Width (1) and Return Matching Rows (2).

I found this to be very slow on a database with just 27,000 records. It took
approx. 12 seconds to read 27,000 records.

When I change the OPTION to 8 (Allow Big Results), it took just 3 seconds to
read 27,000 records. BUT now my application cannot update records anymore
and getting random errors on transactions.

I try setting OPTION=11 (all 3 options added together) and the speed went
back to being slow.

Slave-load-tmpdir Option
I have just installed mysql server 5.0. However, when I was trying to start the server by invoking mysqld, it complained that a directory/file is not found.

I then viewed the variable names and found that the slave-load-tmpdir variable was pointing to a non-existing path. I have tried

mysqld --slave-load-tmpdir=<my new path> --standalone

but whenever I restart the mysqld, the variable is still defaulted to that old path....what should I do to change the default setting for this variable?

Check Table Command - When To Use Which Checking Option
I'm trying to decide which check table option to use for a DB-health-check script for my product. This script is to be run periodically to find and repair damaged tables. My product uses only MySQL, i.e. it does not interact with another DB. I need to find the check table option that would find damaged tables with the highest possible performance.

The 13.5.2.3 CHECK TABLE Syntax documentation states the following:
MEDIUM Scan rows to verify that deleted links are okay. This also calculates a key checksum for the rows and verifies this with a calculated checksum for the keys.

What are they referring to with the word "links"? Are they talking about links to MS Access tables? How do I know if my tables have links? Does the MEDIUM option scan rows only to check deleted links? If so, if I don' t have "deleted links", should I not use this option? By running in MEDIUM mode, will the tables be locked while "check table" is working?

For the other options - CHANGED, FAST, QUICK - will "check table" lock the tables? What access do I have to the tables while check table is running?

Symbolic Links With Windows XP Or Option Datadir
How do you make symbolic links work ?

Drop Down Menu: Option Equal To All Others In The List
I would like to create a drop down menu in a form that selects distinct arrays from a columname, inserts them into a drop down menu, but then I also want one of the options to be equal to all of the rest. I would end up with a drop down structured like this:

All colors
Red
Blue
Green
Purple

Root Login Does Not Work Correctly Without -h Option
For example, I would expect to be able to sign in by using.

mysql -u root -p

The above gives me accessed denied.

Now, I need to do.

mysql -h <hostname> -u root -p

It seems like a simple problem that I have not been able to solve by searching here and google.

Solaris 8 Daemon Fails Because Unknown Option?
I guess people did not see my post from the install thread... I am really really stuck now! Does anyone work on Solaris???

Whatever option I use to start the daemon I get this:

050310 15:27:35 mysqld started
050310 15:27:35 [ERROR] /opt/mysql/bin/mysqld: unknown option '--~'

Please Help

Note that I am using the binaries from this site.

Show All Entries, Then Give An Edit Or Delete Option
I want to show all the entries that are in a database. below each of them I want a radio button that when checked will either allow them to edit or delete the entry. How might I do this?

Enable The Option Flag Return Matching Rows
I would like to know if it's possible to enable the "Return matching rows" flag with a connection string. With a dsn connection i already know how can i do this.

Binding Option Button Controls On Unbound Forms
I am using an MS Access 2002 as a Frontend to a MYSQL 5.0.18 database server backend. I am attempting to set up unbound forms using a dsn-less ADO connection. I have been able to bind the textbox and combobox controls to the fields within my form however I am having difficulties binding boolean field types to my option button controls.

1) Has anyone had any success in binding option button controls to MySQL boolean fields?

2) On another point, in the unbound forms do you set up your own navigation controls or are you able to utilize the standard form navigation controls provided by Access.Again it seems the option button controls do not stay synchronized to the current record.

3) Also after creating a recordset and binding it to my form and binding the controls, I close the recordset and the connection object.After making changes to a current record, if I navigate to the next record in the recordset any changes I made in the previous record are automatcially reflected in the MYSQL tables. The user is not prompted to save changes; it does it automatically.I'm new to using ADO and was surprised to see that this was possible since the connection object had been closed.How do you go about preventing the direct writing to MySQL without informing the user that they are doing so?Where is the code for the navigation buttons events?Is it possible to 'hook' into them?

Best Way To Deal With Linking Tables And Foreign Keys When InnoDB Is Not An Option.
Title covers most of it.

On database insertion I suffer from a lack of transactions, which means I can enter the data into the primary database, then have the database fail with exactingly bad timing and fail when I am making my entries in other tables or the linking table.

On data deletion I suffer from a lack of foreign key constraints so again the database can fail after I delete my entry from my main table, but before I enter the data for my linking tables.

My biggest conern is that I end up with data in the linking tables but not in the main table. Then if I tried to re-enter that main entry with those linking table entries I would get an error due to duplication of the primary key (concacted id of the two foreign keys) in my linking table.

I am considering elaborate if loops in my php to try and catch errors and delete the whole entry if the errors occur. The problem being that the errors will occur when the database is misbehaving so my odds that the delete will work might be somewhat low.

Has anyone else had to work withou InnoDB much in scenarios like this?

Error In Command Line: Mysql: Unknown Option '--ansi'
Whenever I try to run 'mysql' from the command line (windows server 2k3), I get the following message: mysql: unknown option '--ansi'

This occurs if I try to start mysql with just the mysql command or if i try to specify a user, password, and db.

Root User Denied Access To Fetch User List.
I can still log onto MySQL administrator or the command line program but I somehow appear to have lost all priveliges to alter or view the user list from this account. Even under the command line interface I can login but it tells me access is denied when I try to alter "root" permissions on a database.

I cannot seem to log onto any of the other accounts created but obviously if I could get into the user admin I could solve this.

Retrive Category Names Where Categoryid Is Different From User To User
I am trying to retrive category names where categoryid is different from user to user

I know LIKE works with one int(1), but I want it to work with more ints (1,3,5)
SELECT * FROM `categories` WHERE categoryid LIKE (1) Working

SELECT * FROM `categories` WHERE categoryid LIKE ( 1, 5 ) Not working

Copy User Privileges To A Newly Created User.
I have just created a user with specific permissions to certain tables
in different databases. Now I have to create serveral more users with
the same permission. Is there a command in MySQL that allows me to
create the new user by copying the privileges from a template user?

Deleted Root User From 'user' Database!
I so stupidly deleted the root user from my mysql > user database. Now I can't login to mysql. I uninstalled the rpm and reinstalled it but it still won't let me setup a new root user. How can I delete the mysql data files so that I start again, fresh? Where are these files located? I can't find them anywhere after removing the RPM but they are obviously there because upon reinstalling the RPM I'm still in the same position--I try to do

mysqladmin -u root password 'password'

but it says "Access denied for user root@localhost"

Deleted Root User From Mysql.user !!!
While trying to grant access to root user, i deleted all entries for root from mysql.user.

I've tried to use root% (anonimous built-in administrator user) but to no good).

Is there another admin user i could use to run mysql monitor and insert root records to mysql.user? I've read

Could I use a copy of the mysql.user table?

I'm using version 5.0.16-standard on Linux Fedora Core 3.

Before ruinin the root user, i made a backup of a databasefrom the same server (not mysql database); i was wondering if that backup contains the mysql.user information somehow?

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.

SET Option Removing Leading "0" In Stored Procedure.
I'm new at this but I'm just trying to write a stored procedure to do a few things for me as follows.

Basically I want to provide a mobile number to my store procedure and get it to query the db - sounds easy enough, however for the life of me I can't work out how to specify the variable in the SET command for the stored procedure to treat the mobile number as a VARCHAR etc... i.e. - for it NOT to remove the leading "0". - here is the example.... I've made the example as simple as possible and as close to the example in the stored procedure guide too. Code:

User@localhost And User@domain.com
I have been following a tutorial for a mail server which uses mysql, mainly postfix

all through the tutorial i have been asked to put a user and password in the files for the database..

which i have done

root and pass1

in the log files the error shows as

warning access denied for user root@domain.com ( using password : yes )

when i log on from the shell, to mysql

and purpously get the password wrong, I get
access denied for user root@localhost ( using password : no )

i have checked the password is correct..

is the part after the @ the issue, and how can i tell mysql that root@domainname.com is a valid user???

Disable -- User Option

I would like to use unix user names to login to mysql. If I create a mysql user xxadmin and leave the password empty other unix users can use the xxadmin with the --user option . How can I make sure that only the unix user xxadmin can login as mysql user xxadmin ?