My experience with the Windows client and linux / mysql server:
When sqldev is used in a Windows client and mysql is installed on a linux server, this means that sqldev network access to mysql.
Assuming mysql is already running and the databases you need to access are healthy:
• Provide sqldev version (32 or 64). If 64, and to avoid access to the path, copy the actual 64-bit version of msvcr100.dll to the ~ \ sqldeveloper \ jdev \ bin directory.
but. Open the msvcr100.dll file in notepad and find the first occurrence of "PE"
i. "PE d" it is 64. ii. "PE L" it is 32.
b. Note: if sqldev is 64 and msvcr100.dll is 32, the application gets stuck at startup.
• For sqldev to work with mysql, the JDBC jar driver is required. Download it from mysql website.
but. Driver Name = mysql-connector-java-xxxx
b. Copy it to the location associated with the sqldeveloper directory.
from. Set it in the sqldev menu Tools / Preferences / Database / Third-party JDBC driver (add entry)
• In the file for changing the Linux / mysql / etc / mysql / mysql.conf.d / mysqld.cnf file
bind-address = 127.0.0.1 (this local Linux host)
and change to
bind-address = xxx.xxx.xxx.xxx (real real IP address or computer name in Linux) if DNS is not working)
• Log in to linux mysql and provide the necessary access, for example
# mysql -u root -p
GRANT ALL ON root @ 'yourWindowsClientComputerName' IDENTIFIED BY 'mysqlPasswd';
flush privileges;
restart mysql - sudo / etc / init.d / mysql restart
• Run sqldev and create a new connection
but. user = root
b. pass = (your mysql pass)
from. Select the MySql tab
i. Hostname = the linux IP hostname ii. Port = 3306 (default for mysql) iii. Choose Database = (from pull down the mysql database you want to use) iv. save and connect
That is all I had to do in my case.
Thank,
Ale