RE: forget root password

http://www.mysql.com/doc/R/e/Resetting_permissions.html after starting mysql with the --skip-grant-tables, you'll have to execute a grant statement http://www.mysql.com/doc/G/R/GRANT.html GRANT ALL PRIVILEGES ON *.* TO root@localhost INDENTIFIED BY 'somepassword' WITH GRANT OPTION; then

RE: I deleted my root user!

http://www.mysql.com/doc/R/e/Resetting_permissions.html after starting mysql with the --skip-grant-tables, you'll have to execute a grant statement http://www.mysql.com/doc/G/R/GRANT.html GRANT ALL PRIVILEGES ON *.* TO root@localhost INDENTIFIED BY 'somepassword' WITH GRANT OPTION; then

RE: Slow updates with two keys in where.

MySQL can only use 1 index per query. So take your first query for example: update forum set approved='N' where id=644122 or thread=644122 it can only use the id key OR the thread key, not both. and since you have an 'or' in your query MySQL must scan the entire table for either id being

Re: User Defined Functions.

http://www.mysql.com/doc/A/d/Adding_UDF.html thanks, -- Andrew - Original Message - From: Julio Faerman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 27, 2001 3:11 PM Subject: User Defined Functions. Can i create my own functions with mysql ?

Re: Connection limit per user

In the changes to 3.23.34 http://www.mysql.com/doc/N/e/News-3.23.34.html o Added option max_user_connections to mysqld. and in the show variables doc http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html o max_user_connections The maximum number of active connections for a single user (0 = no

Re: undelete records ?

the deleted rows will get re-used by inserts. however, you can always run OPTIMIZE TABLE XXX and that will clear the deleted rows thanks, -- Andrew - Original Message - From: Steve Wright [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 19, 2001 12:03 PM Subject:

TCP_NODELAY: what systems?

Hi guys, In the latest MySQL release (3.23.44) it was noted: o TCP_NODELAY was not used on some systems Which systems would this affect? and is this client side or server side? thanks, -- Andrew - Before posting, please

Re: Inner selects

no mysql right now (3.23) does not support inner selects. however, it looks like you could join the 2 tables to get the result you want I'm assuming there are 2 tables inside the emp database ? or is emp the table ? anyway here is an idea: select d1.ename, d1.deptno FROM emp.table1 d1,

Re: auto_increment vs. heap tables

good point. the only real way to duplicate auto increment logic is to create a new table with 1 row and 1 field. and lock, select, and update that row. thanks, -- Andrew - Original Message - From: Johnny Withers [EMAIL PROTECTED] To: 'Andrew Schmidt' [EMAIL PROTECTED] Sent: Thursday

Re: Looks like any user can read the mysql db!

I'm not sure how you were able to do that. Especially since you didn't provide exactly what you did. But here's what I get as ROOT (all privileges): mysql load data infile '/usr/local/var/db/mysql/mysql/user.MYD' into table t; ERROR 1085: The file '/usr/local/var/db/mysql/mysql/user.MYD' must

Re: Looks like any user can read the mysql db!

] ...var/db/mysql (8) # ll /usr/local/var/db/mysql/mysql/user.MYD -rw-rw 1 mysql mysql 1498 Jun 29 14:29 /usr/local/var/db/mysql/mysql/user.MYD [dev-405:andrew] ...var/db/mysql (9) # thanks, -- Andrew - Original Message - From: Jose de Leon [EMAIL PROTECTED] To: Andrew Schmidt [EMAIL

Re: UPDATE which changes nothing gets duplicate error - bug?

In the change log for 3.23.29: Fixed a bug in UPDATE involving multi-part keys where one specified all key parts both in the update and the WHERE part. In this case MySQL could try to update a record that didn't match the whole WHERE part. I think that was fixed. Try upgrading your mysql

Re: UPDATE which changes nothing gets duplicate error - bug?

REPLACE as INSERT. thanks, -- Andrew - Original Message - From: John Nagle [EMAIL PROTECTED] To: Andrew Schmidt [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 2:58 PM Subject: Re: UPDATE which changes nothing gets duplicate error - bug? That sounds like

Re: mysqldump bug during regenerate enum field.

but mysqldump generates an invalid statement. mysql CREATE TABLE TESTBADDUMP ( - e_test enum('0','1') NOT NULL default '' - ); ERROR 1067: Invalid default value for 'e_test' mysql I think that's what the orignator is trying to show. That mysqldump is generating an

Re: What is the for in ' safe_mysqld --log '

that's a unix shell command that basicly puts the process in the background. if you type that command at your console you'll notice you get a prompt right away. This allows safe_mysqld to run in the background (somewhat like a daemon) thanks, -- Andrew - Original Message - From:

Re: does show create table work?

I believe show ceate table was added in mysql 3.23 and subsequently 3.22 will not have it. thanks, -- Andrew - Original Message - From: Rob Agar [EMAIL PROTECTED] To: Mailinglist MySQL COM [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 11:48 AM Subject: does show create table work?

missing doc: identified by password

Doing a : mysql show grants for root@localhost; +---+ | Grants for root@localhost |

Re: missing doc: identified by password

I guess I didn't phrase my point properly due to the emails I have been recieving =). I'm just stating that this feature isn't documented in the manual though it probably should be. sorry for the confusion. thanks, -- Andrew - Original Message - From: Andrew Schmidt [EMAIL PROTECTED

Re: MySQL 3.23.36 STILL Having Major Problems

taken from the manual: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SHO W_PROCESSLIST SHOW PROCESSLIST shows you which threads are running. You can also get this information using the mysqladmin processlist command. If you have the process privilege, you can see

Re: MySQL 3.23.36 STILL Having Major Problems

() - they weren't properly closing the SQL connections (Zeev) cut regards, -- Andrew - Original Message - From: Hunter Hillegas [EMAIL PROTECTED] To: Andrew Schmidt [EMAIL PROTECTED]; mySQL List [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 3:04 PM Subject: Re: MySQL 3.23.36 STILL

bug report

(*) from test where foo in (2); +---+--+ | NOW() | count(*) | +---+--+ | |0 | +---+--+ notice the date field is blank. Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:Andrew

Re: mysql uses 99% cpu under freebsd 4.3

Have you tried this under a 'stable' version of freebsd? In FreeBSD 4.2 beta, mysql would crash with user locks. Not mysql's fault. now, I understand RC's are generally stable; but I would still make sure that this bug doesn't show up in a stable os. regards, -- Andrew - Original

Re: history file

it matters what you run the mysql client as if I'm root root: # mysql -u foo -p the program mysql is running as root and hense writes the history file to root's home dir. if I'm me andrew: $ mysql -u foo -p it'll write it to ~andrew/.mysql_history regards, -- Andrew - Original

Re: problems with linking

make sure you have -L/usr/local/mysql/lib/mysql/ in your compile and make sure that /usr/local/mysql/lib/mysql/ is in your shared object cache. ldconfig -r will list your current cache entries. if /usr/local/mysql/lib/mysql/libmysqlclient.so.10 is not in there then add the path: