RE: How do you remove a user from the grant table?!!

*mysql> create user 'test'@'localhost' identified by 'pass';* Query OK, 0 rows affected (0.00 sec) *mysql> GRANT CREATE, DELETE ON *.* TO 'test'@'localhost';* Query OK, 0 rows affected (0.00 sec) *mysql> select * from information_schema.user_privileges where grantee like "'test'@'localhost'";* +-

RE:grant user create privilege

mysql -u root -ppassword mysql> create user 'user'@'localhost' identified by 'password' ; mysql> grant create on *.* to 'user'@'localhost'; mysql> flush privileges; mysql> quit mysql -u user -ppassword mysql> create databas

Re: super-smack on mysql 5.0 solaris 10 x86_64

Hi Ujang I could reproduce the same error mentioned by you in the actual post even after having all of the packages for MySQL. Figuring out the what could be the problem . Thanks & Regards Sudhir Menon

Re: super-smack on mysql 5.0 solaris 10 x86_64

5rt * < Package that contains the library in my system. *Pathname: /opt/csw/mysql5/lib/mysql/libmysqlclient.so.15* Type: symbolic link Source of link: libmysqlclient.so.15.0.0 Referenced by the following packages: CSWmysql5rt Current status: installed Thanks & Regards Sudhir Menon

Calculating Full Table Scan Percentage/Ratio.

+ handler_read_first + handler_read_next + handler_read_key + handler_read_prev ) * Thanks & Regards Sudhir Menon

Re: super-smack on mysql 5.0 solaris 10 x86_64

Hi, Kindly ignore my first post, as that link was with respect to compiling super-smack on Solaris, which i found useful. As far as the problem is concerned can u check the below 1. Check if you have mysql4client package installed. 2. If then install mysql5client 3. Ensure that the binaries and

Re: super-smack on mysql 5.0 solaris 10 x86_64

Hope this link has some workaround. http://mysqldatabaseadministration.blogspot.com/2006/10/mysql-benchmarking-4-compiling-super.html Meanwhile i do check out. Thanks & Regards Sudhir Menon

Re: How could i check the following values in MySQL Server 5.0

My reply was with regards to the answer in this post. http://lists.mysql.com/mysql/214827 Anyways thanks for the concern from your end.. Mike :) My query was answered. Thanks & Regards Sudhir Menon

How could i check the following values in MySQL Server 5.0

Thanks Amit ... Thanks & Regards Sudhir

How could i check the following values in MySQL Server 5.0

Hi all, I would like to check or set the following values in MySQL Server . How can that be done ? 1. MySQL Database Free Space for any database. 2. Maximum Database size allowed. 3. Calculate Index Size. 4. Maximum table size 5. Free table space 6. Free Index space 7. Calculate Table size T

Cannot login to MySQL5.0 after compiling MySQL5.1

Thank You... Res, Ananda for the reponse to myquery... It works fine now.. :)

Cannot login to MySQL5.0 after compiling MySQL5.

Yes, mysql by default sets the socket file in the below directory /var/lib/mysql/mysql.sock. But why does it refer to /tmp/mysql.sock file then, as that was the error which was given when i tried to login to mysql. Is that hard-coded for MySQL5.1 source code, which is what i wanted to know ? Th

Cannot login to MySQL5.0 after compiling MySQL5.1

Hello, I have mysql-5.0.22-2.1.0.1.rpm version installed on RHEL5.1 system. I have been trying certain benchmarking tools and found that MySQL5.1 has inbuilt benchmarking tool known as "mysqlslap". Since the tool is not available for MySQL5.0, i have downloaded the source rpm MySQL-community-5.1.2