Mysql Remote problems

Source
Setup privilegies

When you connect to a MySQL server, it checks it’s grants table (the “user” table in the “mysql” database on the MySQL server) against the IP address of the connecting MySQL client machine. If there are NO MATCHING ENTRIES in the “host” column in the “user” table in the “mysql” database, mysqld will IMMEDIATELY CLOSE THE CONNECTION with ERROR 1130.
For example, a client (192.168.0.2) tries to connect to it’s MySQL server (192.168.0.100) and gets:
[root@dbclient ~]# mysql -u jennifer --password=toughPassword -h 192.168.0.100 my_database
ERROR 1130 (HY000): Host '192.168.0.2' is not allowed to connect to this MySQL server
[root@dbclient ~]#
..a simple “telnet” TCP-connection test proves that the problem is not a firewall – the client is able to get to port 3306 (the MySQL port) on the database server:
[root@dbclient ~]# telnet 192.168.0.100 3306
Trying 192.168.0.100...
Connected to 192.168.0.100.
Escape character is '^]'.
GHost '192.168.0.2' is not allowed to connect to this MySQL serverConnection closed by foreign host.
[root@dbclient ~]#
If we login to the MySQL server, and run “mysql”, we can look at the grants table:
[root@dbserver ~]# mysql mysql

mysql> SELECT host,user FROM user;
+-----------------+-----------+
| host            | user      |
+-----------------+-----------+
| 192.168.0.6     | jennifer  |
| 192.168.0.7     | jennifer  |
| 127.0.0.1       | root      |
| ::1             | root      |
| localhost       | jennifer  |
| localhost       | root      |
+-----------------+-----------+
11 rows in set (0.00 sec)

mysql>
We can see that “jennifer” *is* authorized to connect from several IP addresses, but not from the client IP 192.168.0.2. So we add the GRANT for access from THAT IP:
mysql> GRANT ALL PRIVILEGES ON my_database.* TO 'jennifer'@'192.168.0.2' IDENTIFIED BY 'toughPassword';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
..and voila:
[root@dbclient ~]# mysql -u jennifer --password=toughPassword -h 192.168.0.100 my_database

mysql>

Comentarios

Publicar un comentario

Entradas más populares de este blog

Fix Audio Windows on MAC

Imagen
  [GUIDE]  DSDT override  eGPU error 12 fix (Windows only)   here   ◄  Mac owners  please work through this thread to solve error 12 before doing a  DSDT override here   ◄  pre-compiled  DSDT overrides   - load or use as reference when making your own   Introduction   A Windows system's DSDT table root bridge definition (ACPI PNP0A08 or PNP0A03) is usually confined to a reserved 32-bit space (under 4GB) budgetted to be large enough to host the notebook's PCIe devices. A watermark TOLUD value is then set and locked in the system firmware. Windows OS honors the root bridge definition and will allocate PCIe devices within it. macOS ignores the root bridge constraints as too does Linux when booted with the 'pci=noCRS' parameter. Neither of those OS require a  DSDT override  and can allocate freely in the huge 64-bit PCIe address space.   When retrofitting a eGPU, an   error 12 (This device cannot find enough free resources that it can use)  can occur  against an eGPU in Win
Leer más

Tkinter tkFileDialog module

Imagen
Tkinter tkFileDialog module tkFileDialog  is a module with open and save dialog functions. Instead of implementing those in  Tkinter GUI  on your own. Related courses Tkinter GUI Application Development Projects Overview An overview of file dialogs: Function Parameters Purpose .askopenfilename Directory, Title, Extension To  open  file: Dialog that requests selection of an existing file. .asksaveasfilename Directory, Title, Extension) To  save  file: Dialog that requests creation or replacement of a file. .askdirectory None To  open directory Tkinter Open File The  askopenfilename  function to creates an file dialog object. The extensions are shown in the bottom of the form (Files of type). The code below will simply show the dialog and return the filename.  If a user presses cancel the filename is empty. On a Windows machine change the initialdir to “C:\”. Python 2.7 version: from Tkinter import * from Tkinter import * import Tkinter , Tkconstants ,
Leer más

Using real data types in VHDL

Imagen
Using real data types in VHDL    Apart from the standard types like integer and std_logic_vector's VHDL also offer  real  data types. But a real data type has a big disadvantage. It is not synthesis-able. It can be used only for simulation purposes. This disadvantage limits its use to a large extend, but there are plenty of projects where we look only for simulation results.   Before starting the coding part of a VHDL project,one has to decide whether the project to be implemented on a real FPGA or just a computer simulation is required. If it has to be ran on FPGA, then forget about the real package and use only synthesis-able data types like std_logic,integer etc... Otherwise you can reduce the time and complexity of your project by using real data types. The real data type is defined in the library called  MATH_REAL . So you have to include the following line before the entity declaration in the code: use ieee.math_real.all; The math_real package also offers some elemen
Leer más