MySQL 入门
之前mac系统下打开xampp之后 workbench可以顺利的连上。之后我修改了xampp的安全性，设置了密码。结果workbench就显示no connection可是在 terminal里输入mysql -u root -p 可以进去。但是mysql我是和 xampp建立了一个连接才可以直接在terminal里输入的。现在不知道该咋弄了
那说明你的安全性设置生效了你要检查workbench里面的mysql连接设置是否正确第二个就是检查你的安全性设置是否允许其它地址或用户名访问
MySQL 入门
服务热线:400-678-8266Tutorial Table of Contents:
# : TCP, SSH and AWS EC2 RDS
Related YoLinux Tutorials:
Description:
The MySQL Workbench "community edition" is an open source GUI data modeling, schema design, SQL development and database admin client for the MySQL database.
It allows easy point and click discovery and investigation of any MySQL database.
MySQL Workbench Installation:
Oracle MySQL Workbench installation on Linux and Microsoft Windows platforms.
Download MySQL Workbench:
Dependencies/Prerequisites:
Pexpect: from RHEL6 Server DVD (not on the RHEL6 Workstation DVD)
/media/RHEL_6.0 x86_64 Disc 1/Packages/pexpect-2.3-6.el6.noarch.rpm
LibZip: libzip-0.9-3.1.el6.x86_64.rpm
rpm -ivh libzip-0.9-3.1.el6.x86_64.rpm
Download MySQL Workbench: mysql-workbench-gpl-5.2.33b-1el6.x86_64.rpm
Install: rpm -ivh mysql-workbench-gpl-5.2.33b-1el6.x86_64.rpm
Start: ./sqlworkbench.sh
Microsoft Windows:
Unzip each download.
Start MySQL Workbench:
MySQL Workbench main screen:
MySQL Workbench Connection Configuration:
One must configure MySQL Workbench to attach to the MySQL database.
MySQL Workbench allows one to store multiple DB server connections, each with their own unique configurations.
Three MySQL Workbench supported connection types will be detailed here:
Direct Connection to port 3306 on the DB Server:
This connection is the simplest but also the least desirable as it is not encrypted.
Configure a "New Connection":
Select "File" + "New Connection":
Hostname: Be sure to assign a name to your configuration where the "hostname" is the network node name, its' IP address or "localhost" if the database is running locally.
The port is probably the MySQL default "3306".
Specify the login and password
Specify the database name ("Default Schema").
Select "Store in Vault..." to enter password
Test Connection (optional: select this button to test)
Storing passwords (optional):
Hit OK and then "Store password in vault"
The MySQL database can be configured for remote client access by both granting remote access to the database user (all hosts "%") explicitly and the MySQL "bind-address" configuration in /f.
For more see
(check out the security section to configure for remote access)
[Potential Pitfall]:
Upgrade to 5.7.4 or using passwords generate in MySQL 4.1 or earlier:
The password encryption hashing algorithm was changed and thus old passwords generated with the old algorithm fail to authenticate correctly.
Backwards compatibility with the old scheme was eliminated in version 5.7.4.
Error: (MySQL Workbench)
Authentication plugin 'mysql_old_password' cannot be loaded: /usr/lib/mysql/plugin/
mysql_old_password.so: cannot open shared object file: No such file or directory
Reseting the password will encrypt the password with the new hashing algorithm and authentication will work.
SET PASSWORD FOR 'userx'@'localhost' = PASSWORD('supersecretpassword');
For more details see
SSH Connection to the DB Server Host with a Local Connection to Port 3306:
Using ssh over the network is significantly more secure and thus recommended.
It does require issuing a login account on the database server in addition to database access.
Select the "SSH Password" "Store in Keychain" button to enter the server login password.
Select the "Password" "Store in Keychain" button to enter the MySQL database login password.
SSH tunnel and AWS EC2 RDS:
Amazon cloud configurations often include a web server (EC2 instance) and an Aurora database RDS (Relational Database Service) configured on a local VPC (Virtual Private Cloud) using non-routable local IP addresses.
The web server Linux instance will typically have a public Amazon "Elastic" IP address.
Using MySQL Workbench requires a ssh tunnel connection to the Linux web server using the ssh key and public IP address and "tunneling" the connection to the separate RDS server over the private VPC network.
MySQL Workbench supports this type of connection
Set the values as follows:
Connection Name - Create a name to identify your connection
Connection Method - Select "Standard TCP/IP over SSH" from the drop down list (Don't use the default: Standard(TCP/IP)). On the three tabbed pane, fill the following values found under "Parameters" tab (the other two tabs (SSL and Advanced) are not used).
SSH Hostname - Provide the IP address or Public DNS name of the Amazon EC2 instance which will be used as the proxy to create the connection with the DB instance.
SSH Username - Provide the login id of the Amazon EC2 instance
SSH Password - Select "Clear" if using the ssh key to log-in
SSH Key File - Provide the Private Key (xxx.pem) used to connect Amazon EC2 instance via SSH
MySQL Hostname - Provide the Endpoint of the DB instance created in Amazon RDS
Username - Provide the database Master User id of the DB instance created in Amazon RDS
Password - Click on Store in Keychain.. button and type the password provided while creating the DB instance in Amazon RDS.
Using MySQL Workbench:
Reverse Engineer an existing Database:
Generate a Database Schema Diagram from an existing MySQL database:
In this example we are looking at the Nagios MySQL database schema.
Create and store a MySQL connection configuration as shown above.
From the toolbar select "Database" + "Reverse Engineer ..."
Choose your "Stored Connection"
Select "Next"
A new dialog box will appear:
Select "Next"
On this dialog box select the database schema to be processed: "nagios"
(All databases which have been generated within your MySQL instance will be displayed)
Select "Next"
The following panel appears (default options shown):
Select "Next"
The following dialog panel allows you to filter the database schema by table. The default is to select all:
If you choose "Show Filter" this will allow you to choose which tables are displayed in the diagram.
Select "Execute"
A new dialog box will appear:
Select "Next"
A Results summary panel will display:
Select "Close"
The schema model for the database will display. Drag and arrange as you wish.
You can select from the toolbar "Arrange" + "Autolayout"
Generate a Database Schema Diagram from a SQL file:
Generate a Workbench model:
From the toolbar:
File + New Model
File + Import + Reverse Engineer MySQL. Create script...
This opens dialog box. "Browse" or enter the SQL file name. Select "Execute" button
Select "Create EER Model from SQL Script" under the heading "Data Modeling"
This action launches a new dialog box.
Select "Next". In the next dialog box, select "Close"
Select "Model" + "Create Diagram from Catalog Objects"
(This will generate a full data model diagram. You can now rearrange the layout for the most appropriate presentation.)
Generate image file: File + Export + Export as PNG...
MySQL Workbench Tips:
Specify layout size: (required for large schema models with many tables requiring allot of space for the diagram.)
From the toolbar select "Model"
Select "Diagram Properties and Size"
Set the number of pages for the layout height and width.
"MySQL, Second edition"
Paul DuBois
ISBN # , New Riders Publishing
"Managing and Using MySQL"
by George Reese, Randy Jay Yarger, Tim King
ISBN # , O'Reilly
"MySQL Cookbook"
by Paul DuBois
ISBN # , O'Reilly
"High Performance MySQL"
by Jeremy D. Zawodny, Derek J. Balling
ISBN # , O'Reilly
"The Definitive Guide to MySQL, Second Edition"
Michael Kofler
ISBN # , APress
"MySQL Certification Study Guide"
by Paul Dubois, Stefan Hinz, Carsten Pedersen
ISBN # , Sams
Please enable JavaScript to view the
Advertisements神州5分彩计划热新闻
澎湃新闻APP下载
神州5分彩计划:热门推荐114网址导航小木虫 --- 600万学术达人喜爱的学术科研平台
&&查看话题
workbench流固耦合问题。总是出错
本人小白，做一个流固耦合的案列，一直出现问题。总是说The CFX Solver for system Fluid Flow (CFX) did not produce a results file. Detailed information can be found in the output file for the run.
是什么问题，大家给帮忙看看啊。谢谢了，速度啊
ERROR # has occurred in subroutine SERVE_CLIENTS.& && && &|
| Message:& && && && && && && && && && && && && && && && && && && &&&|
| The connection between this CFX process and an external process& & |
| has died unexpectedly.&&The following error was received:& && && & |
|& &External process&&: ANSYS& && && && && && && && && && && && && & |
|& &Error experienced : Read& && && && && && && && && && && && && &&&|
|& && && && && && && && && && && && && && && && && && && && && && &&&|
| ** This error is fatal:&&Terminating ANSYS CFX Solver execution ** |
| Please review the output, error and log files from both the CFX& & |
| and external processes to determine the cause of the error.&&
An error has occurred in cfx5solve:& && && && && &&&|
|& && && && && && && && && && && && && && && && && && && && && && &&&|
| The ANSYS CFX solver exited with return code 1.& &No results file&&|
| has been created.& &
An error has occurred in cfx5solve:& && && && && &&&|
|& && && && && && && && && && && && && && && && && && && && && && &&&|
| ANSYS Solver terminated with return code 3840
你好，能再介绍下吗，cfx中，双击打开之后，这些路径不都是定义好的吗，你说的改一下，是改到什么地方呢？
北京学而思教育科技有限公司 地址：北京市海淀区北三环甲18号中鼎大厦A座1层102室 电话：010-