Hello,
currently on this version of MySQL a database has been built for me to use. and following
privileges are given: I am not able to create a table on my own. what privileges I need to
create and modify tables in this database?
mysql Ver 14.12 Distrib 5.0.27, for sun-solaris2.9 (sparc) using EditLine
wrapper
mysql> show grants;
+-------------------------------------------------------------------------------------------------------+
| Grants for
myuserid@%
|
+-------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'myuserid'@'%' IDENTIFIED BY PASSWORD '*4EF5......6' |
| GRANT SELECT, INSERT, UPDATE, DELETE ON `mydb`.* TO
'myuserid'@'%'
|
+-------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql>
at % means I can do the operations from other hosts too? using ssh.
thank you.
