Re: Root

2003-08-03 Thread Sherwin T. Ang
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

Re: MySQL connection problem

2003-03-27 Thread Sherwin T. Ang
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

Re: MYSQL Database - followup

2003-03-26 Thread Sherwin T. Ang
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

Re: MYSQL Database

2003-03-26 Thread Sherwin T. Ang
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

Re: Apache/PHP question

2003-03-14 Thread Sherwin T. Ang
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

Re: Starting with Innodb

2003-02-28 Thread Sherwin T. Ang
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

Re: speeding up mysql client

2003-02-28 Thread Sherwin T. Ang
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

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

2002-12-09 Thread Sherwin T. Ang
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

Re: Installing mysql in redhat linux 7.1

2002-09-03 Thread Sherwin T. Ang
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

Re: Is Addition To Previous Post

2002-04-02 Thread Sherwin T. Ang
-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

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

2002-03-21 Thread Sherwin T. Ang
. 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