Posts Tagged ‘privileges’

What statement should be run after manipulating user data in a MySQL database with SQL statements?

I’m thinking it’s mysql>FLUSH PRIVILEGES but I just want to be sure. Thanks.

How to move users and privileges from one MySQL server to another?

I used "mysqldump -A" to copy some databases out and then "mysql" to import them back into another server. This works ok but all the user logins and privileges are lost. Is there an easy way to move the users and privileges?

Thanks!