Mysql privileges

[RamboMambo]

How To Create a New User and Grant Permissions in MySQL from Sentora

Creating database with name xxx and creating user with name yyy then Map Database, after do that does this got all Permissions/privileges or i must go to myadminphp?

Also what is option for Remote Access?

Allow from any IP

Only from single IP

What i choose?

Thanks!!

[apinto]

Greetings RamboMambo
Please follow this guide (http://ubuntuguide.net/enable-remote-acc...untu-linux) to enable Remote Access to mysql.
After that you can use the Allow from any IP (or single IP) to allow remote access.

[Me.B]

Only from single IP would be enough and more secure if you plan only to use the DB from the server and never using a remote access.

All IP may allow you to use tools like mySQL workbench to access DB.

Best you firewall MySQL port 3306.

[apinto]

I agree with you Me.B, however even from single IP it is needed to add the server IP to config files.
At least on my server I couldn't use the feature before that.

[RamboMambo]

Greetings @[RamboMambo]
Please follow this guide (http://ubuntuguide.net/enable-remote-acc...untu-linux)  to enable Remote Access to mysql.
After that you can use the Allow from any IP (or single IP) to allow remote access.

i am not ask this? in cpanel when make database and user

Select the privileges you want to grant to the user or select “All Prvileges” to grant all of them, so i ask how to works on sentora?

[Me.B]

Under sentora the user have "ALL PRIVELEGES" that allow him to work with db beside permissions settings.

There is no such granular control currently BUT you can do it easily if you log using root/phpmyadmin and downgrade/upgrade user permissions.

M B