How can we get the role information in MYSQL?

Like we get in ORACLE from USER_ROLE_PRIVS table.

There is no support for groups of users or SQL ROLES (which are groups of privileges) in MySQL.

It is not mentioned in the list of new features in 5.0, or in the roadmap of future development for MySQL 5.1 or 5.2.

If I have installed mysql using "mysql-essential-5.1.34-win32.msi" on "Comp1" and I want to connect to Comp1-> Mysql server from Comp2.

Then Is there any client requirement on Comp2 (like Oracle we have client) or I need to install "mysql-essential-5.1.34-win32.msi" this on Comp2 also.

If Client is required, Where Should I get this client?

Also If I need to access mysql server installed on windows from Unix platform(linux, Solaris, HPUX) So what are the steps to do on all these Unix platform to get connection on windows mysqlserver.


Amit

I am trying to build the my project on HPUX (HP-UX oscar B.11.11 U 9000/800 741028561 unlimited-user license) which access the Mysql library. But it is giving error as :

Error : MySQL51/lib/hpux/libmysqld.a(client.o) - shared library must be position independent. Use +z or +Z to recompile.

I am using this option in building:
aCC -Wl,+s,-E,+vnocompatwarnings -z -g0 -b -Wl,-Bsymbolic.

I also tried using the +Z, +z, also added CFLAGS=-fPIC in makefile.Still it is giving error.

I have taken the mysql library from : mysql-5.1.34-hpux11.11-hppa2.0w.tar.gz

Can you please suggest the solution?