This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

Mysql privileges
#1
Mysql privileges
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!!
Reply
Thanks given by:
#2
RE: Mysql privileges
Greetings RamboMambo Smile
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.
My Sentora Resources
[Module] Mail Quota Count | Vagrant Box with Sentora

[Image: vanguardly-logo-micro.png]
Graphic and Web Design. Development.
www.vanguardly.com


Reply
Thanks given by:
#3
RE: Mysql privileges
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.
No support using PM (Auto adding to IGNORE list!), use the forum. 
How to ask
Freelance AWS Certified Architect & SysOps// DevOps

10$ free to start your VPS
Reply
Thanks given by:
#4
RE: Mysql privileges
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.
My Sentora Resources
[Module] Mail Quota Count | Vagrant Box with Sentora

[Image: vanguardly-logo-micro.png]
Graphic and Web Design. Development.
www.vanguardly.com


Reply
Thanks given by:
#5
RE: Mysql privileges
(05-04-2015, 06:45 PM)apinto Wrote: Greetings @[RamboMambo] Smile
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?

[Image: 5_cpanel_mysql_user_database_privileges.pnghttp:]
[Image: mysql5.pnghttp:]
Reply
Thanks given by:
#6
RE: Mysql privileges
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
No support using PM (Auto adding to IGNORE list!), use the forum. 
How to ask
Freelance AWS Certified Architect & SysOps// DevOps

10$ free to start your VPS
Reply
Thanks given by: RamboMambo


Possibly Related Threads…
Thread Author Replies Views Last Post
MySQL Database user prefix MosleyCale 1 4 ,868 10-17-2020, 09:11 PM
Last Post: Ron-e
Senator crash problem with mysql provokas 3 9 ,569 08-20-2020, 04:11 AM
Last Post: Your Creator
MySQL remote access... pixelbat 11 37 ,831 05-02-2020, 07:40 PM
Last Post: upendra.sahu1990@gmail.com

Forum Jump:


Users browsing this thread: 1 Guest(s)