Delphi6 's new dbexpress is specifically designed to deal with databases such as mysql,db2,interbase,oracle, and when used, take care to copy Libmysql.dll to the current directory or system directory (98:SYSTEM,NT:SYSTEM32) and ensure that your 3306 ports are connected to the remote server.
SOURCE program:
InterfaceUsesWindows, Messages, sysutils, variants, Classes, Graphics, Controls, Forms,Dialogs, Dbxpress, DB, sqlexpr, Stdctrls, Comctrls, FMTBCD
Tags: Connect client permissions name log on using use MySQL server fromThere are 2 ways to resolve this issue: localhost changed to% 1. Go to the MySQL bin directory Note: Root is the administrator user name, password is the user root password: Mysql-u root-p Password Mysql>use MySQL; Mysql>update User Set host = '% ' where user = ' root ' and host = ' localhost '; Mysql>flush privileges; Note: The MySQL client connecting to this server needs to be
: Show grants for ' root ' @ '% ';| GRANT all privileges on * * to ' root ' @ '% ' identified by PASSWORD ' *e995d71a1f13cce285e250b75338a9b93fe48c9b ' with GRANT OP tion | Show grants for ' shopsys ' @ '% ';| GRANT USAGE on * * to ' shopsys ' @ '% ' || GRANT all Privileges "Shopsys". * to ' shopsys ' @ '% ' |The comparison is visible, the ordinary user does not have identified .... Authorization action: Grant all privileges on * * to ' shopsys ' @ '% ' identified by ' 123456 ' with GRANT OPTION
The following command line is run in a terminal: Note Article to: http://blog.csdn.net/liumaolincycle/article/details/50052619 installation XRDP
sudo apt-get install XRDP1 1 Installation Vnc4server
sudo apt-get install Vnc4server1 1 Update system Download source
sudo apt-get update1 1 Installation Xubuntu-desktop
sudo apt-get install Xubuntu-desktop1 1 writes to Xsession xfce4-session
echo "Xfce4-session" >~/.xsession1 1 Open XRDP Service
sudo service xrdp restart1 1 View IP address
Ifconfig1 1
Problem Description:Newly installed a server, open the SSMs link sever on the server locally, one and normal. But when I use my own local link, the following error occurred. a network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or is not accessible. Verify The instance name is correct and that SQL Server is configured to allow remote connections.Solution:1. Open the server-side SQ
Problem reason: remote login mysql error after migrating database to MySQL host:1130 ' 10.0.0.8 ' is This MySQL ServerWORKAROUND: Switch to MySQL host and refresh MySQL database after entering MYSQmysql> FLUSH privileges;Successful remote login successful after switching back again:Thanks to the Netizen's solution: http://blog.csdn.net/bingjianit/article/details/54384299Remote Login MySQL Error: Error 113
PHP automatically chooses to connect to the local database or remote database. For the mysql.class.php file, see www.jb51.netarticle25496.htm. The Copy code is as follows :? Php contains Mysql operation class include_onceMysql.class.php; local mysql data $ mysql_l Mysql. class. php file see http://www.jb51.net/article/25496.htm
The code is as follows:
// Contains the Mysql operation classInclude_once
Why cannot I connect to the remote desktop? It is a server built on windows 2008. The server is on a university campus, but on campus it can be connected to the remote desktop of the server, but it cannot be connected when it is out of the campus. why?
Reply to discussion (solution)
Does the firewall enable related interfaces? (I think it's a bit suspended
Remote connection to Oracle is troublesome. It usually takes the oracle client to be installed. You can use instantclient to easily connect to a remote Oracle database.
1. Create a Directory D: \ Oracle_Cleint to store related files. Create a Directory D: \ Oracle_Cleint \ NETWORK \ ADMIN to store tnsnames files.2. Download the corresponding version and the sys
D:/Oracle/product/10.2.0/db_2/Network/admin
6. Modify the tnsnames. ora file D:/Oracle/product/10.2.0/db_2/Network/admin/tnsnames. ora in the Oracle installation path and addXxx =(Description =(Address_list =(Address = (Protocol = TCP) (host = 192.168.12.42) (Port = 1521 )))(CONNECT_DATA =(SERVICE_NAME = Po)))Note: The preceding paths may vary depending on the actual installation path of oracle.CPS is the name of the database displayed on the front-end when PL/SQL developer connects to a
I believe many friends of VMware vcenter Converter tools have been very familiar with, but here I still long-winded use the official text to explain, for no use of friends over the concept.
VMware vcenter Converter can automate and simplify the conversion process between physical and virtual machines and virtual machine formats, simply by enabling users to quickly, easily and effortlessly implement Microsoft Windows Physical machine transformations and convert third-party image formats to VMwar
be written)
npgsqldataadapter SDA = new Npgsqldataadapter (strSQL, con);
DataSet ds = new DataSet ();
Sda. Fill (ds, "terminals");//Put the executed data in the data set
//pds. DataSource = ds. Tables[0]. defaultview;//the data in the data set into the paging data source
//datalist1.datasource = pds;//bound datalist
Datalist1.datasource = ds. tables["Terminals"];
Datalist1.databind ();
Con. Close ();
DBExpress added by Delphi6 is used to deal with Mysql, DB2, Interbase, Oracle and other databases.Copy the file to the current directory or system directory (98: system, NT: system32), and ensure that your port 3306 is consistent with the remote server.Source program:InterfaceUsesWindows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,Dialogs, DBXpress, DB, SqlExpr, StdCtrls, ComCtrls, FMTBcd, Grids,DBGrids, Provider, DBClient, DBLoc
1. Installing X-window#yum check-update#yum groupinstall "X window System"#yum Install gnome-classic-session gnome-terminal nautilus-open-terminal control-center liberation-mono-fonts2. See if VNC is installed in the CentOS system# rpm-q VNC vnc-server3. Installing VNC#yum Install Tigervnc-server-y4. Run and set the password#vncserver5. Configure the user#vim/etc/sysconfig/vncserversLast line added: vncservers= "1:root"Restarting VNC#service vncserver Restart6. Client ConnectionVNC website Downl
Generally, the hosted code on GitHub is public. Anyone can view, copy, and download the code. Private Projects are charged. Therefore, you can build a git service for your own use.
First install git:
Sudo apt-Get install git
After installation, createBareWarehouse
Git init -- bare # create a raw git Repository
Note: DifferencesGit initAndGit init -- bareDifferences:
Git init is used to create a repository to store the project source code. After git init, The. Git folder and project source
The service uses the Redis+mongo cluster because the MONGO cluster machine memory is too small, so migrate to other larger space machines to do stress testing.
But after the machine migration, client call, found the following error
Mongo connecting error Failed to connect to: *.*.201.18:27018:remote Server has closed the connection
MONGO cannot connect, but
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.