Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1]
1
MySQL / Re: New MariaDB 11.0.x version gives error
« on: September 25, 2023, 08:00:43 PM »
Thank you
2
MySQL / Re: New MariaDB 11.0.x version gives error
« on: September 25, 2023, 04:59:14 PM »
Did the upgrade to 11 finally work, or stay on 10.6 ?
3
MySQL / Re: User access from specific IP
« on: September 28, 2018, 05:11:41 PM »
I've been successful at changing the IP to address a single IP.
The steps are, create a new user that has locahost access (NOT %). Then enter the phpMyAdmin as the root user. Go to the MYSQL - DB table, find the user and click on the localhost field to edit and replace it with the IP. Do the same for the MYSQL - USER table. If you edit the record (not just click on the localhost field) it changes other fields that have default values and it wont work.
After, restart MYSQL from the CWP Panel. Your user should be updated with the correct IP address (instead of localhost) and access to the created database will only have have access for localhost (if setup) and from the user at IP address specified.
The steps are, create a new user that has locahost access (NOT %). Then enter the phpMyAdmin as the root user. Go to the MYSQL - DB table, find the user and click on the localhost field to edit and replace it with the IP. Do the same for the MYSQL - USER table. If you edit the record (not just click on the localhost field) it changes other fields that have default values and it wont work.
After, restart MYSQL from the CWP Panel. Your user should be updated with the correct IP address (instead of localhost) and access to the created database will only have have access for localhost (if setup) and from the user at IP address specified.
4
MySQL / User access from specific IP
« on: September 18, 2018, 02:54:12 PM »
When creating a new user, you can only choose form [%] or [localhost].
Can a user be created that can only access SQL through a specific host / IP.
I can see the users in MYSQL - DB / USER (logged in as root on phpMyAdmin), however when I change the 'host' field of a newly created user into something else like a hostname ot IP address, the user doesn't show up in the MYSQL Manager in CWP.
Can a user be created that can only access SQL through a specific host / IP.
I can see the users in MYSQL - DB / USER (logged in as root on phpMyAdmin), however when I change the 'host' field of a newly created user into something else like a hostname ot IP address, the user doesn't show up in the MYSQL Manager in CWP.
Pages: [1]
