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
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
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
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
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
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
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
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
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
-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
. 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
11 matches
Mail list logo