Tag Archives: DBeaver

Dbeaver cannot execute database script

Explain the function of static keyword and final keyword in Java in detail>>>

< div class=”htmledit_ views”> & lt; p>& amp; nbsp;& lt;/ p>

< p>& lt; strong> I checked the related questions on the Internet and wrote a step by myself to make it easy to find in the future/ strong>& lt;/ p>

< p>& lt; strong> Here I am connecting to the MySQL database. Take MySQL as an example to illustrate: & lt/ strong>& lt;/ p>

< p>& lt; strong> In the process of using dbeaver, someone gave several SQL files to import directly into the database. The normal process should be on the database & lt/ strong>& lt;/ p>

< p>& lt; strong> Right click – & amp;> Tools-&> Execute script, and then select the corresponding file to execute. But in this process, it is suggested that: & lt/ strong>& lt;/ p>

< p>& lt; strong>& lt; a href=”%20http://blog.csdn.net/ngl272/article/details/70217499%20″ rel=”nofollow” target=”_ blank”> DBeaver Client home is not specified for connection</ a>。& lt;/ strong>& lt;/ p>

< p>& lt; strong> The reason for the above situation is that a local client option was not filled in when the database connection was established, so it could not find MySQL & lt/ strong>& lt;/ p>

< p>& lt; strong> There are some things you need to execute the script. If you have not established a database connection, you can fill in this option when establishing a database connection& lt;/ strong>& lt;/ p>

< p>& lt; strong> If a connection has been established, you can right-click the connection – & amp;> Edit connection and then add the local client option& lt;/ strong>& lt;/ p>

< p>& amp; nbsp;& lt;/ p>

< p>& lt; strong> This local client is the location where you install the database. You should know where it is when you install it under windows; Mac is generally & lt/ strong>& lt;/ p>

< p>& lt; strong> The following path: usr/local/mysql-5.6.7-macos10.12-x86_ 64 (this is my path, all in the/usr/local/folder & lt/ strong>& lt;/ p>

< p>& lt; strong> Find your own MySQL folder. By default, this folder is hidden. You can enter & lt; directly through Command + Shift + G/ strong>& lt;/ p>

< p>& lt; strong>/ Usr/local and open the corresponding MySQL folder& lt;/ strong>& lt;/ p>

< p>& amp; nbsp;& lt;/ p>

< h1 style=”margin- left:0px; “>& amp; nbsp;& lt;/ h1>

< p>& amp; nbsp;& lt;/ p> & lt;/ div>