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

[Sudhir Menon]

*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';*
++---++--+
| GRANTEE| TABLE_CATALOG | PRIVILEGE_TYPE | IS_GRANTABLE |
++---++--+
| 'test'@'localhost' | NULL  | DELETE | NO   |
| 'test'@'localhost' | NULL  | CREATE | NO   |
++---++--+
2 rows in set (0.00 sec)

*mysql REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'test'@'localhost';*
Query OK, 0 rows affected (0.00 sec)

*mysql select * from information_schema.user_privileges where grantee like
'test'@'localhost';*
++---++--+
| GRANTEE| TABLE_CATALOG | PRIVILEGE_TYPE | IS_GRANTABLE |
++---++--+
| 'test'@'localhost' | NULL  | USAGE  | NO   |
++---++--+
*
http://dev.mysql.com/doc/refman/5.0/en/revoke.htmlREVOKEhttp://dev.mysql.com/doc/refman/5.0/en/revoke.htmlremoves
privileges, but does not drop
mysql.user table entries. To remove a user account entirely, use DROP
USERhttp://dev.mysql.com/doc/refman/5.0/en/drop-user.html

mysql drop user 'test'@'localhost;

mysql select * from information_schema.user_privileges where grantee like
'test'@'localhost';
Empty set (0.00 sec)
*

RE:grant user create privilege

[Sudhir Menon]

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















Regards
Sudhir Menon

Re: super-smack on mysql 5.0 solaris 10 x86_64

[Sudhir Menon]

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

[Sudhir Menon]

Kindly check with the below commands, u will get the details of the package.

pkginfo SUNWmysqlu
system  SUNWmysqlu mysql - MySQL Database Management System (usr
component)
[EMAIL PROTECTED] # pkginfo -l SUNWmysqlu
   PKGINST:  SUNWmysqlu
  NAME:  mysql - MySQL Database Management System (usr component)
  CATEGORY:  system
  ARCH:  sparc
   VERSION:  11.10.0,REV=2005.01.08.05.16
   BASEDIR:  /
VENDOR:  Sun Microsystems, Inc.
  DESC:  mysql - MySQL Database Management System (usr component)
4.0.24   
PSTAMP:  sfw10-patch20050627114310
  INSTDATE:  Sep 23 2008 18:59
   HOTLINE:  Please contact your local service provider
STATUS:  completely installed
 FILES:  176 installed pathnames
   6 shared pathnames
  31 directories
  47 executables
   17634 blocks used (approx)

--

pkgchk -l SUNWmysqlu


Part of the output


*Pathname: /usr/sfw/lib/libmysqlclient.so.12*
Type: symbolic link
Source of link: libmysqlclient.so.12.0.0
Referenced by the following packages:
SUNWmysqlu
Current status: installed





pkgchk -l *CSWmysql5rt *     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

[Sudhir Menon]

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

[Sudhir Menon]

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 .so files are in PATH.
4. Recompile super-smack again.

I am using a CSW package other than the default SUNW package, let me see if
i could reproduce the problem.



Thanks  Regards
Sudhir

Calculating Full Table Scan Percentage/Ratio.

[Sudhir Menon]

Hi All,

I want to calculate Full Table Scan Percentage/Ratio, so i had searched and
found the below formula for it. Will that give the correct value ... Any
other way to calculate the same ?

*1-  (handler_read_rnd_next + handler_read_rnd) /
(handler_read_rnd_next + handler_read_rnd + 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

[Sudhir Menon]

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

[Sudhir Menon]

Thanks Amit ...




Thanks  Regards
Sudhir

How could i check the following values in MySQL Server 5.0

[Sudhir Menon]

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




Thanks  Regards
Sudhir

Cannot login to MySQL5.0 after compiling MySQL5.1

[Sudhir Menon]

Thank You...  Res, Ananda for the reponse to myquery...

It works fine now.. :)

Cannot login to MySQL5.0 after compiling MySQL5.1

[Sudhir Menon]

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.28-0.rhel5.src.rpm and tried to get the binary mysqlslap
so that i can execute it in the same
machine running MySQL5.0 and benchmark the same.

But after compiling the tarball i was not able to login to mysql using :
mysql -u root -p . It gave me the below error.
Cannot connect to /tmp/mysql.sock, which is not the socket file as it is
/var/lib/mysql/mysql.sock.

Although i could login to mysql by issuing this command :-  ln -s
/var/lib/mysql/mysql.sock   /tmp/mysql.sock

The above scenario should not happen when i have just compiled the source
code.  What could be wrong. Am i trying something wrong ???


Best Regards
Sudhir.Menon

Cannot login to MySQL5.0 after compiling MySQL5.

[Sudhir Menon]

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
?


Thanks