Oracle SQL Developer 连接 Mysql 等数据库-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

Oracle SQL Developer 连接 Mysql 等数据库

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 03:46 PM

developermysqloraclesqlconnect

Oracle SQL Developer 个人感觉是比较好用的工具，因此除了连接oracle之外，还可以连接其他的数据库，如：MySQL，Access等。但是，它默认情况下只能连接Oracle和Access两种，所以要想连接Mysql等数据库，就要手工添加。具体如下步骤： 1.下载mysql-connecto

Oracle SQL Developer 个人感觉是比较好用的工具，因此除了连接oracle之外，还可以连接其他的数据库，如：MySQL，Access等。但是，它默认情况下只能连接Oracle和Access两种，所以要想连接Mysql等数据库，就要手工添加。

具体如下步骤：

1.下载mysql-connector-java-*.zip

2.下载地址可以在mysql的官网找到，Connector/J有几个版本，根据自己需要下载

Oracle SQL Developer 连接 Mysql 等数据库

3.下载后解压缩这里只要mysql-connector-java-*.jar文件，将其放到sqldeveloper目录下的jlib目录下即可。

4. 然后启动Oracle SQL Developer，点击菜单栏工具按钮

Oracle SQL Developer 连接 Mysql 等数据库

5.展开数据库-->点开第三方JDBC，会出现上图，然后点击添加条目按钮

Oracle SQL Developer 连接 Mysql 等数据库

找到刚刚加入到jlib的jar文件，选择添加即可。

成功后会出现如下图的mysql选项卡

Oracle SQL Developer 连接 Mysql 等数据库

6. 在连接前，一定要让Mysql授权用户远程访问，如下

sql>GRANT ALL PRIVILEGES ON *.* TO 'jack'@’10.10.50.127’ IDENTIFIED BY '123456' WITH GRANT OPTION;

是授权jack用户密码是123456在IP地址10.10.50.127的地址登陆，也可以用通配符%代替IP表示任何地址。当然，也要注意防火墙，允许3306端口通信。

OK，你可以尽情用他来工作了

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

How does MySQL handle data replication?Apr 28, 2025 am 12:25 AM

MySQL processes data replication through three modes: asynchronous, semi-synchronous and group replication. 1) Asynchronous replication performance is high but data may be lost. 2) Semi-synchronous replication improves data security but increases latency. 3) Group replication supports multi-master replication and failover, suitable for high availability requirements.

How can you use the EXPLAIN statement to analyze query performance?Apr 28, 2025 am 12:24 AM

The EXPLAIN statement can be used to analyze and improve SQL query performance. 1. Execute the EXPLAIN statement to view the query plan. 2. Analyze the output results, pay attention to access type, index usage and JOIN order. 3. Create or adjust indexes based on the analysis results, optimize JOIN operations, and avoid full table scanning to improve query efficiency.

How do you back up and restore a MySQL database?Apr 28, 2025 am 12:23 AM

Using mysqldump for logical backup and MySQLEnterpriseBackup for hot backup are effective ways to back up MySQL databases. 1. Use mysqldump to back up the database: mysqldump-uroot-pmydatabase>mydatabase_backup.sql. 2. Use MySQLEnterpriseBackup for hot backup: mysqlbackup--user=root-password=password--backup-dir=/path/to/backupbackup. When recovering, use the corresponding life

What are some common causes of slow queries in MySQL?Apr 28, 2025 am 12:18 AM

The main reasons for slow MySQL query include missing or improper use of indexes, query complexity, excessive data volume and insufficient hardware resources. Optimization suggestions include: 1. Create appropriate indexes; 2. Optimize query statements; 3. Use table partitioning technology; 4. Appropriately upgrade hardware.

What are views in MySQL?Apr 28, 2025 am 12:04 AM

MySQL view is a virtual table based on SQL query results and does not store data. 1) Views simplify complex queries, 2) Enhance data security, and 3) Maintain data consistency. Views are stored queries in databases that can be used like tables, but data is generated dynamically.

What are the differences in syntax between MySQL and other SQL dialects?Apr 27, 2025 am 12:26 AM

MySQLdiffersfromotherSQLdialectsinsyntaxforLIMIT,auto-increment,stringcomparison,subqueries,andperformanceanalysis.1)MySQLusesLIMIT,whileSQLServerusesTOPandOracleusesROWNUM.2)MySQL'sAUTO_INCREMENTcontrastswithPostgreSQL'sSERIALandOracle'ssequenceandt

What is MySQL partitioning?Apr 27, 2025 am 12:23 AM

MySQL partitioning improves performance and simplifies maintenance. 1) Divide large tables into small pieces by specific criteria (such as date ranges), 2) physically divide data into independent files, 3) MySQL can focus on related partitions when querying, 4) Query optimizer can skip unrelated partitions, 5) Choosing the right partition strategy and maintaining it regularly is key.

How do you grant and revoke privileges in MySQL?Apr 27, 2025 am 12:21 AM

How to grant and revoke permissions in MySQL? 1. Use the GRANT statement to grant permissions, such as GRANTALLPRIVILEGESONdatabase_name.TO'username'@'host'; 2. Use the REVOKE statement to revoke permissions, such as REVOKEALLPRIVILEGESONdatabase_name.FROM'username'@'host' to ensure timely communication of permission changes.

See all articles