Re: Root
Read http://www.mysql.com/doc/en/Command-line_options.html Start mysqld with the --skip-grant-tables option then change your root password again, then restart mysqld, this time with out the --skip-grant-tables hope that helps. Sherwin T. Ang Tridel Technologies Incorporated PS: you don't have to reinstall mysql for just this. - Original Message - From: FT [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 03, 2003 1:21 PM Subject: Root Hi everyone I am quiet new to DB and MySql I must have made a big mistake by changing the root @ localhost password via phpMyAdmin and now it is impossible to connect from neither the mysql prompt nor phpMyAdmin... Does anyone know how to recover this problem...I did try to reinstall MySql after uninstalling it and rebooted the server but no luck so far... Thanks for the hand Fabrice -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL connection problem
localhost is 127.0.0.1 in most systems unless you modify your hosts file, since 172.16.3.106 is not localhost, connecting thru that localhost will definitely not work for it's not localhost =) it's not a bug i believe. another thing, if you grant a user with a host localhost, and you place a mysql -ublah -p -h172.16.3.106 it wouldn't also work, you need to add a user with that @172.16.3.106 address for it to be allowed to access mysql, well that's with grants and a fairly different story. Respectfully yours, Sherwin T. Ang Systems Administrator Tridel Technologies Incorporated 7F Hanston Building Emerald Avenue, Ortigas Center Pasig City 1605 Philippines Phone: 6345140 Local 1024 Web: http://www.tridel.net Email: [EMAIL PROTECTED] sql, query - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:48 PM Subject: MySQL connection problem Hi, I really don't know whether it is a bug in mysql 4.0.12. I've downloaded 4.0.12 and installed succesfully on my PC(WIN2k with SPack2). I've changed the bind-address to localhost in my.ini and re-started mysql. mysql -h localhost is working fine. mysql -h (ip of my machine) or mysql -h (hostname) ends with the following error: ERROR 2003: Can't connect to MySQL server on '172.16.3.106' (10061) Earlier I had mysql 3.23.48 on the same machine. It used to work fine for all the above three commands. Could you please help me out??? Thanx in adv, RK * * * The information contained in this message is legally privileged and confidential information intended only for the use of the addressed individual or entity indicated in this message (or responsible for delivery of the message to such person). It must not be read, copied, disclosed, distributed or used by any person other than the addressee. Unauthorised use, disclosure or copying is strictly prohibited and may be unlawful. Opinions, conclusions and other information on this message that do not relate to the official business of any of the constituent companies of the TATA CONSULTANCY SERVICES shall be understood as neither given nor endorsed by the Group. If you have received this message in error, you should destroy this message and kindly notify the sender by e-mail. Thank you. * * * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL Database - followup
Your spelling of PRIVILEGES is also spelled wrong =) specifying GRANT ALL PRIVILEGES on *.* to a user will make that user a member of the superuser group such as mysql, just without the GRANT OPTIONS, meaning that user's login wouldn't be able to GRANT other users. if you want to specify the database just do a mydb.* meaning all tables within the mydb database. then, mysqlflush privileges; i hope that helps. Respectfully yours, Sherwin T. Ang Systems Administrator Tridel Technologies Incorporated 7F Hanston Building Emerald Avenue, Ortigas Center Pasig City 1605 Philippines Phone: 6345140 Local 1024 Web: http://www.tridel.net Email: [EMAIL PROTECTED] - Original Message - From: Toto Gamez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 2:11 PM Subject: MYSQL Database i got this mesage when creating a database for twig, I just followed the instruction in twig manual on how to create a database but resulted to this [EMAIL PROTECTED] mysql]# mysql -u root mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 3.23.41 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql CREATE DATABASE maildb; Query OK, 1 row affected (0.00 sec) mysql GRANT ALL PRIVELEGES ON *.* TO toto IDENTIFIED BY mikaela02; ERROR 1064: You have an error in your SQL syntax near 'PRIVELEGES ON *.* TO toto IDENTIFIED BY mikaela02' at line 1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL Database
Do it like this: mysqlGRANT ALL PRIVELEGES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'mikaela02'; You forgot the hostname which is the @hostname is for Respectfully yours, Sherwin T. Ang Systems Administrator Tridel Technologies Incorporated 7F Hanston Building Emerald Avenue, Ortigas Center Pasig City 1605 Philippines Phone: 6345140 Local 1024 Web: http://www.tridel.net Email: [EMAIL PROTECTED] - Original Message - From: Toto Gamez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 2:11 PM Subject: MYSQL Database i got this mesage when creating a database for twig, I just followed the instruction in twig manual on how to create a database but resulted to this [EMAIL PROTECTED] mysql]# mysql -u root mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 3.23.41 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql CREATE DATABASE maildb; Query OK, 1 row affected (0.00 sec) mysql GRANT ALL PRIVELEGES ON *.* TO toto IDENTIFIED BY mikaela02; ERROR 1064: You have an error in your SQL syntax near 'PRIVELEGES ON *.* TO toto IDENTIFIED BY mikaela02' at line 1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Apache/PHP question
The way i do it, i don't put the AddType application/x-httpd-php .php in the httpd.conf as a global entry, since i host sites in VirtualHosts, I only place the AddType application/x-httpd-php .php directive in their respective VirtualHost entry for those sites who needs or pays for php based hosting. .htaccess is also limited so that they wouldn't override the configuration. Am not sure how to implement it on a directory based hosting though. Respectfully yours, Sherwin T. Ang Systems Administrator Tridel Technologies Incorporated 7F Hanston Building Emerald Avenue, Ortigas Center Pasig City 1605 Philippines Phone: 6345140 Local 1024 Web: http://www.tridel.net Email: [EMAIL PROTECTED] - Original Message - From: Defryn, Guy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 14, 2003 9:38 AM Subject: Apache/PHP question I have set apache 2.0 and PHP 4.3.1 as well as mysql. I was wondering how I can disable PHP per user directory?. At the moment everyone can put php scripts on their personal website. I want to limit it to a few users. Cheers Sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Starting with Innodb
Hello Nitin, You can check the error messages in your database directory, it is usually named your.hostname.err it will give hints on why the mysql server won't start. also make sure that the 230mb free on your drive c: doesn't yet include the windows swap file, and your innodb space is less than the total available space of your harddrive. Respectfully yours, Sherwin T. Ang Systems Administrator Tridel Technologies Incorporated http://www.tridel.net - Original Message - From: Nitin Nanivadekar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 28, 2003 9:19 PM Subject: Starting with Innodb Dear friends, I am not getting INNODB support as per describd in mysql manual. my c:\ has only 230MB free can this be a problem? when i make changes in my.cnf as per the manual, 'mysql' stops responding. pls provide detailed guideline. thanking you. nitin. __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: speeding up mysql client
Thomas, Well I guess the best way is to make an insert statement that goes like, INSERT INTO table values (3,'S',1,6,'2002-07-15','The Palm Computing Device',1),(2,'S',6,6,'2002-07-18','Programming for the Palm',1),(4,'S',5,6,'2002-07-1 6','Medical Applications for the Palm Device',1); The above query will connect once and insert all 3 records, The method is called extended insert, and is a much faster method of insert based on the mysqldump man pages when restoring data back to the database. I use --extended-insert in my sql dumps. am not sure if LOAD DATA INFILE is much faster, well on raw data i guess it is. Respectfully yours, Sherwin T. Ang Systems Administrator Tridel Technologies Incorporated http://www.tridel.net - Original Message - From: Thomas Spahni [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 28, 2003 8:37 PM Subject: speeding up mysql client Hi everyone, I'm calling the mysql client from a bash shell script in a loop. It's doing one INSERT query each time. I'm aware that there is some overhead in this procedure, because the client has to connect to the server each time. Question: what are the recommended options to make this as fast as possible? I'm already using --disable-auto-rehash, but what other options could help? Thomas Spahni - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to get MySQL to list current db's ?
You can either use mysqlshow databases; or mysqlshow -uroot -p in the command line. Respectfully yours, Sherwin T. Ang Systems Administrator Internet Manila - Original Message - From: Will Standley [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 12:35 AM Subject: How to get MySQL to list current db's ? I have two sample MySQL db's running on a local Linux box w/Apache... Once I enter mysql from the Linux command line... Is there a way to ask MySQL to list the db's that are currently created? Thanks, Will - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installing mysql in redhat linux 7.1
I use the 4.x branch for innodb support. Hrmm, did you download ALL the rpm's? the client, the server and libs i think. I suggest backup/dump your databases first before doing a reinstall. I also strongly suggest you install from the source so you can customize your installation of MySQL better. Respectfully yours, Sherwin T. Ang Systems Administrator Internet Manila http://www.i-manila.com.ph Tridel Technologies Inc. 7F Hanston Building Emerald Avenue Ortigas Center Pasig City 1605 Metro Manila Philippines (632) 634.5140 Local 1024 - Original Message - From: Peter Goggin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 04, 2002 8:12 AM Subject: Installing mysql in redhat linux 7.1 I have just installed redhat linux 7.1 and now need to install Mysql. with innodb support. I downloaded the rpm (3.23.51) from the mysql site and tried to install it. The process appeared to stop mysql and then complained it could not find a file: /etc/rc.d/mysql A query on rpm -qa | grep mysql showed no changes had taken place. How do I install the latest version of mysql? Should I be using the rpm ? Regards Peter Goggin Regards Peter Goggin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is Addition To Previous Post
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello Marcus, i think you forgot the mysql flush privileges; Regards, Sherwin T. Ang Web Technical Administrator / Programmer Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building Emerald Ave., Ortigas Center Pasig City Philippines Tel: (632) 634-5141/ (632) 634-5140 Local 1040 Fax: (632) 634-5139 - - Original Message - From: Marcus - Videomoviehouse.com [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 02, 2002 6:59 PM Subject: Is Addition To Previous Post Here are some results from what I have tried in a addition to my previous post. mysql GRANT ALL ON *.* TO root@localhost IDENTIFIED BY 'pasword'; ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) mysql show GRANTS for root@localhost; +--- ---+ | Grants for root@localhost | +--- ---+ | GRANT USAGE ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '55' WITH GRANT OPTION | +--- ---+ 1 row in set (0.00 sec) mysql I can set the USAGE setting but anything else I get access denied, I have run out of options please help. I am guessing next thing would be to re-install mysql and rebuild the server? If I copy my tables from my var directory can I copy them back after and have it work? -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use http://www.pgp.com iQA/AwUBPKtVhXHqbCYZYnEDEQKL/gCgjLOVigDDvxjMBIi2QThzPgVaJngAoOGo hdlQjc3d/cqjqDcLwY3GxS4Z =GpJj -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Some more info on what I don't have.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello Louise, Well first of all is that, did you change host providers? well if so, have you made a backup/dump of your database in your old host? if so, are u sure that your new host supports PERL DBI which is needed for you to do database connections via Perl (i am concluding it's perl coz you mentioned cgi) If you are all in luck and still have the old server running, you can try phpMyAdmin and use it to dump the database into a text file, then on your new host, install phpMyAdmin too and then restore the database into the new site. Just ask your new provider for the username, password and maybe the mysql port if ever they changed it. You can get a copy of phpMyAdmin at http://www.phpwizard.net/projects/ it's written in PHP though, but you can use the tool for the database migration. Regards, Sherwin T. Ang Web Technical Administrator / Programmer Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building Emerald Ave., Ortigas Center Pasig City Philippines Tel: (632) 634-5141/ (632) 634-5140 Local 1040 Fax: (632) 634-5139 - - Original Message - From: Louise [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 12:20 AM Subject: Some more info on what I don't have. The site is a search engine site similiar to ooh-canada.com (not that I am plugging their site...lol) but it is the best way to describe mine. I have adcycle on it- that doesn't work. I have link sql which doesn't work. There is e-classifieds that doesn't work. Subscribe Me pro doesn't work Auto rank, auto post, web now doesn't work. Even the links on it don't work. I can't get into any admin for any of the above stuff. Virtually I have only a site that is a mess. And so am I... I sure do hope that someone can help. I don't think it is a big problem but some thing that I have not done in my illiterate mind. Like the wrong linking or like that. Thanks for listening.. Louise -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use http://www.pgp.com iQA/AwUBPJp+iHHqbCYZYnEDEQJyoQCeNCIOjV+R8FhDP7AeR4GQng+vnFwAmwR/ 8X4zTk7ZR0zqiC7yTNum4gE6 =MlAV -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php