Re: Root

2003-08-02 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

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

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

2003-02-28 Thread Sherwin T. Ang
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: speeding up mysql client

2003-02-28 Thread Sherwin T. Ang
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: Apache/PHP question

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

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

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

2003-03-27 Thread Sherwin T. Ang
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: Some more info on what I don't have.

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

Re: Installing mysql in redhat linux 7.1

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