Home Database Mysql Tutorial win7+mariadb免安装版

win7+mariadb免安装版

Jun 07, 2016 pm 04:12 PM
download Install Official website

1.官网下载mariadb-10.0.15-winx64.zip; 2.解压到D:/mariadb; 3.在D:/mariadb目录下新建一个my.ini文件,内容如下: [mysqld]basedir=D:\mariadbdatadir=D:\mariadb\datacharacter_set_server=utf8# 允许最大连接数max_connections=200# 创建新表时将使用

1.官网下载mariadb-10.0.15-winx64.zip;

2.解压到D:/mariadb;

3.在D:/mariadb目录下新建一个my.ini文件,内容如下:

[mysqld]
basedir=D:\mariadb
datadir=D:\mariadb\data
character_set_server=utf8
# 允许最大连接数
max_connections=200
# 创建新表时将使用的默认存储引擎
#default-storage-engine=INNODB 报错
#default-storage-engine=MYISAM
port=3306

federated#解决 [Note] Plugin 'FEDERATED' is disabled.
[client]
port=3306
default_character_set=utf8
#character_set_client=utf8 报错
[WinMySQLAdmin]
Server=D:\mariadb\bin\mysqld.exe
Copy after login

编码格式ANSI!不然会报错:...2003...内容没有留意

4.以管理员身份运行命令行;切换到D:/mariadb

运行:mysqld install MySQL --defaults-file=D:/mariadb/my.ini

运行:net start mysql

注:到这一步,应该不会有错误,如果没有成功。去D:/mariadb/data目录,有一个 你的主机名.err文件,看是哪里的错误。一般比较明显。可以google.

5.这时命令输入mysql,就进入mariadb了。但是没有mysql数据库,推出数据库,执行mysqladmin -u root -p password mima,下一步让输入password,直接enter(默认密码为空)。然后以mysql -u root -p登录,输入你设置的密码mima;

6.这时show databases;就有mysql数据库了。执行以下命令:update user set password=password('mima') where user='root';flush privileges;就更改了。

7.至此,mariadb告一段落。

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

What should I do if I download other people's wallpapers after logging into another account on wallpaperengine? What should I do if I download other people's wallpapers after logging into another account on wallpaperengine? Mar 19, 2024 pm 02:00 PM

When you log in to someone else's steam account on your computer, and that other person's account happens to have wallpaper software, steam will automatically download the wallpapers subscribed to the other person's account after switching back to your own account. Users can solve this problem by turning off steam cloud synchronization. What to do if wallpaperengine downloads other people's wallpapers after logging into another account 1. Log in to your own steam account, find cloud synchronization in settings, and turn off steam cloud synchronization. 2. Log in to someone else's Steam account you logged in before, open the Wallpaper Creative Workshop, find the subscription content, and then cancel all subscriptions. (In case you cannot find the wallpaper in the future, you can collect it first and then cancel the subscription) 3. Switch back to your own steam

How to download links starting with 115://? Download method introduction How to download links starting with 115://? Download method introduction Mar 14, 2024 am 11:58 AM

Recently, many users have been asking the editor, how to download links starting with 115://? If you want to download links starting with 115://, you need to use the 115 browser. After you download the 115 browser, let's take a look at the download tutorial compiled by the editor below. Introduction to how to download links starting with 115:// 1. Log in to 115.com, download and install the 115 browser. 2. Enter: chrome://extensions/ in the 115 browser address bar, enter the extension center, search for Tampermonkey, and install the corresponding plug-in. 3. Enter in the address bar of 115 browser: Grease Monkey Script: https://greasyfork.org/en/

Introduction to how to download and install the superpeople game Introduction to how to download and install the superpeople game Mar 30, 2024 pm 04:01 PM

The superpeople game can be downloaded through the steam client. The size of this game is about 28G. It usually takes one and a half hours to download and install. Here is a specific download and installation tutorial for you! New method to apply for global closed testing 1) Search for "SUPERPEOPLE" in the Steam store (steam client download) 2) Click "Request access to SUPERPEOPLE closed testing" at the bottom of the "SUPERPEOPLE" store page 3) After clicking the request access button, The "SUPERPEOPLECBT" game can be confirmed in the Steam library 4) Click the install button in "SUPERPEOPLECBT" and download

Kimichat official website address list_kimichat official website address list Kimichat official website address list_kimichat official website address list Mar 26, 2024 pm 12:30 PM

The main functions of KimiChat include answering questions, providing suggestions, language translation, knowledge inquiry, solving calculation and mathematics problems, scheduling and reminders, and website and file reading. So what is its official website address? Let’s take a look. Kimichat official website address 1. Official website address: https://kimi.moonshot.cn/2. The chat robot KimiChat can be used by going directly to the official website to register an account. It has powerful Internet search and file upload functions, and it is completely free with no limit on the number of times you can use it. Try it now, you will like it! 4. KimiChat is a large model AI product released by MoonshotAI Dark Side of the Moon. Comparison in performance

How to download foobar2000? -How to use foobar2000 How to download foobar2000? -How to use foobar2000 Mar 18, 2024 am 10:58 AM

foobar2000 is a software that can listen to music resources at any time. It brings you all kinds of music with lossless sound quality. The enhanced version of the music player allows you to get a more comprehensive and comfortable music experience. Its design concept is to play the advanced audio on the computer The device is transplanted to mobile phones to provide a more convenient and efficient music playback experience. The interface design is simple, clear and easy to use. It adopts a minimalist design style without too many decorations and cumbersome operations to get started quickly. It also supports a variety of skins and Theme, personalize settings according to your own preferences, and create an exclusive music player that supports the playback of multiple audio formats. It also supports the audio gain function to adjust the volume according to your own hearing conditions to avoid hearing damage caused by excessive volume. Next, let me help you

How to download Beilehu children's songs How to download Beilehu children's songs Mar 28, 2024 am 11:10 AM

As an indispensable accompaniment to children's growth, Beilehu's children's songs have won the love of countless parents and children with their cheerful melody, vivid pictures and entertaining and educational content. In order to allow babies to enjoy the joy brought by children's songs anytime and anywhere, many parents hope to download Beilehu's children's songs to their mobile phones or tablets so that they can listen to their children at any time, but how to save Beilehu's children's songs? On your mobile phone, this tutorial will bring you a detailed introduction. Users who don’t understand it yet can come and read along with this article to learn more. Beilehu Nursery Rhymes Download Children's Songs Multi-Picture Tutorial: Open the software and select a children's song you want to download. The editor takes "Classic Children's Songs" as an example. 2. Click the "Download" button below the children's song star.

How to install Android apps on Linux? How to install Android apps on Linux? Mar 19, 2024 am 11:15 AM

Installing Android applications on Linux has always been a concern for many users. Especially for Linux users who like to use Android applications, it is very important to master how to install Android applications on Linux systems. Although running Android applications directly on Linux is not as simple as on the Android platform, by using emulators or third-party tools, we can still happily enjoy Android applications on Linux. The following will introduce how to install Android applications on Linux systems.

Where to download files from Quark Network Disk_How to download Quark Network Disk to local area and share Where to download files from Quark Network Disk_How to download Quark Network Disk to local area and share Mar 21, 2024 pm 03:57 PM

As a convenient and practical network disk tool, Quark can help users easily obtain their favorite resources. What if you want to download a file locally? Let the editor tell you now, let’s learn it together! How to download Quark Network Disk to local sharing method 1. First open the Quark software, enter the homepage, and click the [Cloud Icon] on the lower right; 2. Then on the Quark Network Disk page, we click the [Document] function; 3. Then go to the document page, select the file you want to download, and click the [three-dot icon]; 4. After the final click, we click [Download] in the pop-up dialog box;

See all articles