1. Preparatory work
Download MySQL's latest installation-free version mysql-noinstall-5.1.53-win32.zip, extract to related directories, such as: d:\\ Mysql-noinstall-5.1.53-win32. This is the root directory of MySQL.
2. Configure
There are several files under the root directory as follows:
My-small.ini (This is for a small memory (〈= 64MB) system, MySQL will only be used from time to time, it is important that the mysqld daemon does not use a lot
files\mysql-5.7.21-winx64\bin>mysqld--defaults-file=. /my.ini--initialize-insecure2. Installation Service: D:\Program files\mysql-5.7.21-winx64\bin>mysqld--install----Online there is an installation command is mysqld-nt install I tried after at least in win 10 under the MySQL 5.7 is invalid----installation is successful, go to the Control Panel-management tools-service to see if there is a service called M
1. Uninstall the previously installed MySQL serviceCheck the registry hkey_local_machine\system\controlset001\services\mysql, some words delete the item, then return to cmd inside output mysqld--remove Enter, the service Successfully removed. Represents the deletion success.2. Go to the folder directory and locate the My-default.ini file, and copy the name to My.ini.3. Modify the Configuration[Mysqld]#basedir代表自己MySQL的安装根目录Basedir = d:\\mysoftware\\mysql-5.7.9-winx64#datadir代表自己MySQL的数据库保存的目录, i
): Access denied for user ' root ' @ ' localhost ' (using Password:no) Close Service net stop MySQL Open with Safe mode, mysqld--skip-grant-tables At this point, the cursor will always blink. Note, do not move, open another command-line window. 4. The same operation as before came to the bin directory, Login Mysql-u Root-p Password is empty, direct carriage return; We can go in. And then Use MySQL; (Perhaps the previous version of the password header is password,5.7.11 is authenticat
:/mysql Installation Path #根目录datadir = D:/mysql installation path/data #数据文件存放目录Registration system service/Installation service: (need to enter as Administrator)Mysqld-install (MySQL optional, indicates that a MySQL name is registered for the Windows service) or: mysqld--install mysql--defaults-file= "E:program Filesmysql-5.1.58-win32my.ini "To remove: Mysqld-remove (MySQL seems optional) (if the installa
set, remove the # and set as required.Basedir = D:\mysql-5.6.24-winx64DataDir = D:\mysql-5.6.24-winx64\dataPort = 3306# server_id = ...Character_set_server=utf8 # Remove Leading # To set options mainly useful for reporting servers.# The server defaults is faster for transactions and fast selects.# Adjust sizes as needed, experiment to find the optimal values.# join_buffer_size = 128M# sort_buffer_size = 2M# read_rnd_buffer_size = 2M Sql_mode=no_engine_substitution,strict_trans_tables [Client]po
How to configure Tomcat in Eclipse (install free)2013-10-09 23:19wgelgrsh | Category: Java related | browse 642 times Share to:2013-10-10 17:10 The questioner adopted One, determine the placement path of your tomcat. Here I take my own example: "E:\ installation package \apache-tomcat-6.0.29-windows-x86\apache-tomcat-6.0.29". Second, install Eclipse and JDK
defaults to a 8-bit encoded latin1 character set character
-set -server=UTF8; # The default storage engine that will be used when creating a new table default -storage-engine=innodb; 3: At the command prompt, enter mysqld --install MySQL --defaults-file="my.ini" Install MySQL and set "My.ini" as the configuration file. Tip "Service successfully installed." Indicate success; 4: At the command prompt, en
the command in the bin directory of the MySQL installation directory:mysql -uroot -pThis time will prompt to enter the password, remember the 3rd step of the password, fill in can log in successfully, into the MySQL command mode.Previously, MySQL's password authentication plugin was "Mysql_native_password" and now uses "Caching_sha2_password".Because there are many database Tools and link packages do not support "Caching_sha2_password", for convenience, I temporarily changed back to the "Mysql_
access from any host * /Flush privileges;Set the character set:In the My.ini [client] Set default-character-set = UTF8, you can use the Command Line window to correctly import utf-8 encoded SQL file (if the database is created when the selected character set is also uft-8), at this time is normal for the application, However, the command-line window displays garbled characters because the Windows command-line window does not encode and decode Chinese utf-8.At the same time, set the Character-se
Label:1: Start-and-run input cmd command--Enter on command windowCD Unzip the bin folder directory of MySQLEnterExample: CD C:\Documents and settings\administrator\ desktop \mysql\mysql-5.6.24-win32\bin2: Input Mysqld-nt-install command, enter, will appear service successfully installed etc.3: Input net start mysql command, enter, will appear MySQL service has started successfully4: Input mysql-u root command, enter, will appear welcome to the MySQL M
Tags: blog grant span download strong tar auto variable mysqlMySQL for the win Test simple zip installation to understand the beauty of the my.in configuration file (show variables), the local build MySQL service test engine! 01. Download Https://dev.mysql.com/downloads/mysql Mysql-5.6.34-winx64.zip Http://pan.baidu.com/s/1kVKBJgz Password: 1QCF 02, Decompression: Mysql-5.6.34-winx64.zip 03. Modification: My-default.ini--->my.ini Modify My.ini basedir = d:\mysql-5.6.34-winx64 #mysql的
configuration. Here we choose to use the install-free Oracle client. Reason:1. easy to use. 2. not with other dependent Oracle the program conflicts. 1. Download instantclient-basic-nt-11.2.0.3.0.zip Just download the Instantclient-basic-nt-11.2.0.3.0.zip, and the rest is a package that expands according to different needs.: http://www.oracle.com/technetwork/topics/winsoft-085727.html 2.unzip to the loca
file is also replaced with provider= "Oracle.ManagedDataAccess.Client"3, if the data type mapping has been configured (Oracle default type mapping a little pit dad), you need to add the red line below theA probe into whatPerformance testing I would like the official version of the Oracle has certainly done before the official, the test comparison is not professional after all, but a cursory look at the internal implementation of how much can be discerned, if seen before the Oracle-driven DLL (M
Old Version, for reference only!
Before getting started, let's take a look at Red5 and Openmeetings.
Red5 is a free and open-source Flash Streaming Media server Based on JAVA. It is the best open-source software to replace the open-source software provided by Adobe. Moreover, it has incomparable advantages in terms of scalability.
Openmeetings is an open-source video software developed based on Flex. It transmits video data through RTMP and HTTP. Supp
Method 1: Use the Set password commandMysql-u Rootmysql> SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Newpass ');Method 2: Use Mysqladmin
mysqladmin-u root Password "Newpass"If Root has already set a password, use the following methodmysqladmin-u root password Oldpass "Newpass"Method 3: Edit the user table directly with updateMysql-u Rootmysql> use MySQL;mysql> UPDATE user SET Password = Password (' newpass ') WHERE user = ' root ';mysql> FLUSH privileges;T
:\Documents and settings\administrator>cd\C:\>d:D:\>CD ToolsD:\TOOLS>CD MySQLD:\TOOLS\MYSQL>CD binD:\tools\mysql\bin>D:\tools\mysql\bin>mysqld-installTip: Service successfully installed. And the installation is successful.(CMD command: cd\ returns the root directoryD: Enter D driveCD tools into the Tools folder)6. Start, stop, and move out of the MySQL serviceStart MySQL service: net start MySQLStop MySQL service: net stop MySQLMove out of MySQL service: mysqld-removeThe service is started here
Label:Create a new My.ini in the corresponding directory [MySQL] # setting MySQL client default character setdefault-character-Set=UTF8 [mysqld] Skip-grant-Tables #设置3306端口 Port=3306# Set up the MySQL installation directory Basedir=d:\mysql-5.7.Ten-Winx64 # Set the data storage directory for the MySQL database DataDir=d:\mysql-5.7.Ten-Winx64\data # allows maximum number of connections Max_connections= $# The default character set used by the server is a 8-bit encoded latin1 character Set charact
Tags: mysql coded installationReference here: http://www.bkjia.com/sjkqy/989251.htmlSpent more than half an hour, tried the various methods on the Internet, is estimated to be normal installation, modify My.ini, but in their own MySQL folder can not find My.ini, found My-default.ini, thought equivalent to modify this, it seems not ...Method:(1) Copy My-default.ini and rename to My.ini(2) Modification of two places(a) [Mysqld] under AddCharacter_set_server = UTF8(b) Sql_mode=no_engine_substitutio
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.