Re: How can I detect if MySql is already installed?

Hi Zsolt if there is no firewall in between, you may check to see if port 3306 is responding. suomi Zsolt Csillag wrote: Hello, I would like to create a setup program for my demo version that uses MySql database. I need to detect if the target computer has already got the MySql

Re: Last and Last-1

select idTable ... FROM FaxServer ORDER by DateFaxInsert DESC LIMIT 2 suomi Vittorio Zuccalà wrote: Hi, i've a table in a mysql database. It has a lot of field and three of them are: * A counter: IDTable * A date: DateFaxInsert * A Number: NumberFaxInsert I want to obtain the last an

Re: Autoindexing

Hi Tom CREATE TEMPORARY TABLE tt SELECT * FROM your_table; TRUNCATE your_table; UPDATE tt SET your_index = NULL; INSERT INTO your_table SELECT * FROM tt; suomi Tom Ray [Lists] wrote: Hey, I have a really simple question (I hope)..I have a database that has a field in it that autoindexes the

Re: Failed to upgrade from 4.1.16 to 5.0.18

or user 'root'@'localhost' (using password: NO) [EMAIL PROTECTED] ~> mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 to server version: 5.0.18-standard Type 'help;' or '\h' for help. Typ

Re: Failed to upgrade from 4.1.16 to 5.0.18

.sql | /usr/bin/mysql --no-defaults --force --user=root --host=localhost --password=pp --database=mysql Please check the above output and try again. If you get an 'Access denied' error, you should run this script again and give the MySQL root user password as an argument wi

Re: Failed to upgrade from 4.1.16 to 5.0.18

Hi Dave tha' sounds great. i 'll try to do the same immediately. thanks for your help. suomi Logan, David (SST - Adelaide) wrote: Hi suomi, From my understanding (and I have just performed it myself about 2 hours ago on one of my servers), I stopped the server, took a backup o

Re: Failed to upgrade from 4.1.16 to 5.0.18

Hi Dave i did so, but probably in the wrong moment. i got "Access denied" when i run the script. you mean that this should have been the very first step after the upgrade. suomi Logan, David (SST - Adelaide) wrote: Hi, Did you run the bin/mysql_fix_privilege_tables scrip

Failed to upgrade from 4.1.16 to 5.0.18

more carefully: nothing found. 7. back to 4.1.16 which essential step did i omitt? suomi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

upgrade to mysql 5.x?

these issues? suomi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SELECT ... INTO OUTFILE ... and LOAD DATA INFILE ... with a key

alle columns except the primary key column? thanks very much for your interest and understanding. suomi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

how to find out the name of the server

client the name of the server you are connected to? suomi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can connect with PHP to MYSQL

i usually do $link = mysql_connect($server, $userid, $password); and it works, except when the pw is incorrect suomi leegold wrote: I can connect in the php by using 'root' and the root pw. But when I tried adding a user ( sarah ) with GRANT I cannot connect from php. The php is si