Rajeev Prasad mysql Ver 14.12 Distrib 5.0.27 user privileges question
Feb 27, 2013; 09:12
Rajeev Prasad
mysql Ver 14.12 Distrib 5.0.27 user privileges question
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.
Feb 27
Prabhat Kumar Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question
Feb 27, 2013; 23:08
Prabhat Kumar
Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question
Feb 27
Reindl Harald Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question
Feb 27, 2013; 18:55
Reindl Harald
Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question
Feb 27
Stillman, Benjamin RE: mysql Ver 14.12 Distrib 5.0.27 user privileges question
Feb 27, 2013; 18:00
Stillman, Benjamin
RE: mysql Ver 14.12 Distrib 5.0.27 user privileges question
Feb 27
Reindl Harald Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question
Feb 27, 2013; 19:14
Reindl Harald
Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!