Reconfiguration of the computer today, the installation of Java development related environment, in the process of installing MySQL, encountered some problems.Because downloading a free-install version of MySQL 5.7 on the website, you only need to unzip the zip archive during the installation process.After that, you need to modify the data modifications of the Basedir and datadir two items in the My-default
Label:Installation-free configuration:
Append%mysql_home%\bin to the environment variable Path;
Configure the My-default.ini file in the MySQL directory to create a new data folder under the MySQL root directory
Open cmd with administrator privileges, switch to mSQL bin directory, execute mysqld--initialize-insecure--user=mysql
Perform the Mysqld-install installation service, and then start t
This article mainly introduces the MySQL installation-free version of the configuration steps detailed, provided two users of the installation method, you can refer to the use of 1. Prepare work nbsp; Download MySQL's latest version of Mysql-noinstall-5.1.53-win32.zip, extract to the relevant directory, such as: D:mysql-noinstall-5.1.53-win32. This is the root directory of MySQL. nbsp; 2. Configuration nbsp; There are several files in the root direc
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
The following demo is win8/win8.1 installation office2010 Free Edition tutorial, want to know win8/8.1 how to install office2010 Free Edition? The afternoon steps but very detailed oh ~ Interested friends follow the steps to operate it, I hope to help.
1, download and install Office Starter 2010 Online installation pa
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
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.