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

Re: MySQL connection problem

ou 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 Technolog

Re: MYSQL Database

Do it like this: mysql>GRANT 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 Av

Re: MYSQL Database - followup

pecify the database just do a mydb.* meaning all tables within the mydb database. then, mysql>flush 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 Phil

Re: Apache/PHP question

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 Ce

Re: speeding up mysql client

e --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" <

Re: Starting with Innodb

ce 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

Re: How to get MySQL to list current db's ?

You can either use mysql>show 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 PROTEC

Re: Installing mysql in redhat linux 7.1

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: "Pe

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 Hans

Re: Some more info on what I don't have.

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

Re: MySQL gurus - easy one.

Hello Odhiambo, Seems like From and To are MySQL reserved words. http://www.mysql.com/doc/R/e/Reserved_words.html Thanks, Sherwin Ang Web Programmer / Systems Administrator Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building

Re: print database schema

for mysql. Hope that helps. Thanks, Sherwin Ang Web Programmer / Systems Administrator Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building Emerald Ave., Ortigas Center Pasig City Tel: (632) 634-5141/ (632) 634-5140 Local 1040

Re: can login only as root

check out the docs at http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#GRANT Thanks, Sherwin Ang Web Programmer / Systems Administrator Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston

Re: Access Denied!

You dont have the FILE privileges. http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#GRANT Thanks, Sherwin Ang Web Programmer / Systems Administrator Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th

Re: Niebie again

ame values (1,"John"); insert into name values (2,"George"); insert into name values (3,"Chris"); insert into name values (4,"Patrick"); Regards, Sherwin Ang Web Programmer / Systems Administrator Alchemy Solutions http://www.alchemy.com.ph Creative. Techn

Re: mySQL security

s in detail at http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#GRANT Thanks, Sherwin Ang Web Programmer / Systems Administrator Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building Emerald Ave., O

Re: apostrophe's in PHP & MySQL

another approach is using the str_replace() function, just replace the single quote ' with two single quotes '' and database inserts should be fine. http://www.php.net/manual/en/function.str-replace.php Regards, Sherwin Ang Web Programmer / Systems Administrator Alchemy

Where can I download berkeley DB 3.2.9a for MySQL 3.23.46 installation?

] Thanks again, Ziying Sherwin - 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 unsub

Re: Host Access denied

It looks like you dont have the correct privileges on your mysql server to connect from a specified host. Look at the Grant function in mysql manual for more info Sherwin Ang Web Programmer Yesmynet Internet - Original Message - From: Mike <[EMAIL PROTECTED]> To: MySQLList &

Re: Valuable information

This poster should be removed from the list, he's just placing trash in the list --- Sherwin Ang Web Programmer Yesmynet Internet - Original Message - From: Heidi Fredel <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 30, 2001 8:50 PM

Re: Connection to remote Mysql Server.

Rajesh Prakasan I use this free and lighweight SSH client for win32 to access my remote mysql servers on linux check it out at http://www.chiark.greenend.org.uk/~sgtatham/putty/ -Sherwin Yesmynet Internet #mysql - undernet irc - Original Message - From: "Rajesh Prakasan&quo