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 database testdb1; mysqlcreate database testdb2; Regards Sudhir Menon

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

* 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

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

Calculating Full Table Scan Percentage/Ratio.

+ handler_read_first + handler_read_next + handler_read_key + handler_read_prev ) * 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

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.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

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 ?