MySQL: User access and DB overwriting -


mysql -u someuser -db somedb -h someip -c 

this command used shell connect db. assume "somedb" database there.

i told userid has read access. so, happen on using command? old "somedb" overwritten new "somedb"?

please reply soon

if have read privilege, nothing overwritten.

mysql -u someuser -db somedb -h someip -c 

using above command, connecting database. there not over-written connecting database. nor deleted whether use account read-only privileges or full privileges.

remember database names unique on same host.

refer https://dev.mysql.com/doc/refman/5.0/en/connecting.html mysql database connection.


Comments