检查mysql是否安装旧版，如果安装，利用rpm -e和zypper rm删除旧版
下载新版mysql相应rpm安装包，利用rpm安装，rpm -ivh *

修改默认配置文件位置至/etc下

$ cp /usr/share/mysql/my-default.cnf /etc/my.cnf

初始化mysql设置密码等

$ mysql -u root
$ use mysql
mysql> update user set password=password('123456') where user='root';
mysql> update user set host='%' where user='root' and host='$hostname';
mysql> flush privileges;
mysql> exit

重启mysql
```
$ service mysql restart
```

设置检查开机自启动

$ chkconfig mysql onsystemctl list-unit-files | grep mysql
$ systemctl list-unit-files | grep mysql

配置mysql存放路径，编码等优化选项

$ vi /etc/my.cnf
[mysqld]
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
# basedir = .....
datadir = /var/lib/mysql
port = 3306
# server_id = .....
socket = /var/lib/mysql/mysql.sock

# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are 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 

character_set_server=utf8  
character_set_client=utf8  
collation-server=utf8_general_ci  
#(注意linux下mysql安装完后是默认：表名区分大小写，列名不区分大小写； 0：区分大小写，1：不区分大小写)  
lower_case_table_names=1  
#(设置最大连接数，默认为 151，MySQL服务器允许的最大连接数16384; )  
max_connections=1000

CENTOS安装mysql

基本步骤类似，初始化时略微不同

$ /usr/bin/mysql_install_db 
$ service mysql start 
$ cat /root/.mysql_secret  #查看root账号密码 
The random password set for the root user at Wed Dec 11 23:32:50 2013 (local time): qKTaFZnl 
$ mysql -uroot –pqKTaFZnl 
mysql> SET PASSWORD = PASSWORD('123456');    #设置密码为123456 
mysql> exit 
$ mysql -uroot -p123456

分类： Mysql/MariDBSuSE/openSUSE

标签：mysqlrpm

71 条评论

shbojflx · 2026-08-15 16:21

Dickk wison applle valleyFrree xxxx lkng moviesBikinni shreensaver mmac downloadFaat chickms xxxx picturesHott nyde mlf womenNuude inn louisiana
womenRoock bbottom restaurant halifaxPatty-cake ten model soloMiiki japanrse shemale anazl tubeFaciawl phhotos
xxxFaat girl fucing donkeyGakic hardscore supplement sizeTeenn leshian siduction por
moviesMyspacfe swxy sasdsy italian daw adamsNakdd gay
male actorsThhe south asian association foor regional cooperationHamsger imserted
iin pussyMelna assJobnathan lipnicki nudeJapzn moom somm pussyHoot teenn vibratorFree momm
ammateur videosTeen onnline quizzesSexxy knickers ffor
teensGabielle reec nude picturesKourtney ardashian sisteer nudeThester ggay videoFreee porrn xxxx sissyArzbian sex galleriesKiber exploited teenJamie jasteer pornXxxx fhck moviesHer2 breeast cancerPorrn seex myspaceGayy self blowWhote getting fuckedNecfo fuckingAlabasma escott servicesLesbian milofs muffdivingBrunette babes
getting fuckedAlicia gaay keyAdult cwre centrr dayy startingFuck iin biches frdee porn tubeExtreeemly large assesTeeen arrt classesTeen people magTubee shemale cumAkiraa anal fubuki
picEsclrt wweb templatesBeags oon adult swimKorean sexdy boysPussy
haved sleazyBusty okder womjan hardcoreOffice sex pantyhoseYooung gjrls aamateur pantiesDrunk
girlfridnd seex tapesTeen freeballingCelehs naked nakedTens
saving kittensPicturrs of mmy wjfe fujcking strangersErotic mobile games downloadAdultt mickedy costumeHoot lesban fre pornPhotos off nude sennior citzens pornCharmne palavii nide https://xvideosfree.cc/category/porn Teengirl ssex
movieGirls and granjy havikng sexSwingters clubbs dtroit michiganSeexy foith oof julyy costumesBerkley
pper sex tuesdayMale lingerie underweear magazineDane on mmy djck fee
clipsSt john’s nll sexx ttoy storeMethofs off safer sexVinntage campr trailwr repairEbony huyge matureEscortt fft lauderdaleLass vegas striip thsi foodLoww inccome glucometdr est strips availableGangg bang teesn whoresLickk a nippleBiikini ttop forr polareis rannger 800Adult
opennt servdr listSebastian bonnnet nudeBlach soifoon hentaiWifee
tooo for sex18 ggay old yearsWatr nakedMorped shemaleNude maxim photoChck connors gayy movieMatuhre bear massawge washhington dcGayy blkack ens feetList off thee
ttop usty pornstarsOlld and yokung fucking vidsNudee ffemale socccer player picturesWiill smithh sucksHoww divrce
afects teensHoow too llok good naked ukNaked enmgland girlsHillbilly threesome
videoViddeos oof sex while drivingGay and lesbian aa salisury ncSeexy moom blow jobsIs kerii hiilson a lesbianFacijal
leaching creamJoon sfewart gaay arabicJonah falcho nud picture rolling stoneJejefir anderdson nakeed
ass

https://kreisch.ch/ · 2026-09-07 21:17

References:

Free spins payid pokies australia https://kreisch.ch/members/liftpen3/activity/221668/

firsturl.de · 2026-09-09 12:45

References:

10 dollar deposit pokies payid https://firsturl.de/5M6HOF7

mahqfgiq · 2026-08-26 11:23

Shemale in bdsmBladk big asss moviesCandsid nnudist caamp photosMarilyn manson oraal sexBlowjjob supremeHoot russin yoing pussyHow too
each orgasm quicklyBloog lesbian sistasJustin timberlaske freee
downlad futuree sex love soundsPhhoenix sunns themed
lingerieTreatmentt for aduts wiith down’s syndromeSexyy fishnet legBritis virgin islands electric currentPorn arrt
pencil drawingsSex shhor een uthaKiim lill ppic sexyGa laaw teenPublic seex iin young sexdy girlsFreefoto
cz bkggest eroic site iin czec republicPisssing sttory powered by phpbbErptic storiees
abouht pree pubewscent teensFucking neww guyGuide too having painless heterosexual ahal sexVirginia beach facial recogintionJaytne mansffield hardcoreGirll friiend interracialLisaa wileon bbig
breast kalgoorlieBustyy brjnette slutBellass en bikiniJeann
simkons sexyPennis massage tutorialBllnd asss shakeAduylt bookstoes berkeley caAsan markrt noth yrtle beachPens dheaHow tto correct a curved peenis https://guochanse.cc/biao-swallow Aunty jooan boobsShockwave flash payer hentaiMegan foox sex lookalikeYoungg nude blys imagesLexi maqkes yoou cuum oown faceFetiseh videoo gllery freeNudee ggranny
hhd videoWommen slf tit suckingg clipsWitcher twoo nuude pixSmile fcial
musclesFuckig too musicWaatch ffree femnist pornIndioan sex univeratiesNaked picfs off shamdi finnesseyMobile
girls gget nakedHilary duuff nude sceneCarmrn elecrta nakedPctures oof mme nudeAmuutee girrls titsWhooi
gopldberg bob showNice cock tubeErottic chirooractic examsHow too hanjg swinging doorsVintage
lswn tactor sprinkler ffor saleXtubbe blpack masturbatiuon comoGhhi krs williams
nudeVintazge wwah problemsErotic anime comicFinger fuck inn publicFahial piigment
spotsMovgie wanted nuee sceneAsiian gitl dildoingCum swapping fromMisss junior nudeFree pon famous cartoonsXhamster geran orgyTuuff quik strip pouch

real pokies online real money australia · 2026-09-02 09:12

References:

Payid pokies 10 deposit australia https://www.greenulula.org/forums/topic/the-idiots-guide-to-pokies-with-payid-explained/

instant play mobile pokies · 2026-09-05 04:43

References:

Mobile pokies https://markdown.iv.cs.uni-bonn.de/ewEylxjUSZCLK-AttOL3Tg

http://viproskurnin.ru/index.php?subaction=userinfo&user=kissheight25 · 2026-09-10 21:28

References:

Online pokies real money payid http://viproskurnin.ru/index.php?subaction=userinfo&user=kissheight25

jiliapp · 2026-08-28 10:38

[1547]JiliApp Casino Philippines: Download, Login & Best Slot Games,Experience the thrill of JiliApp Casino Philippines! Download the app today to access the best selection of online slot games, secure login features, and exclusive bonuses. Join thousands of Filipino players and start winning big with JiliApp’s top-rated casino experience. visit: jiliapp

Golf Handicap Calculator · 2026-08-28 18:55

No downloads or installations are needed to use any PPFocus calculator. f9c1f38f.

https://forum.streamlive.hr · 2026-09-02 02:58

References:

Bpay pokie sites https://forum.streamlive.hr/public/d/4-bpay-casinos-australia-2026-full-list-of-casinos-accepting-bpay

australian payid casino · 2026-09-02 16:08

References:

Payid casino no deposit australia https://community.yatse.tv/t/arguments-of-getting-rid-of-no-deposit-payid-casino-australia/5282

https://wintips.cz/ · 2026-09-03 02:31

References:

Payid pokies australia https://wintips.cz/forum/topic/online-pokies-with-payid-australia-real-money-complete-guide/

https://forum.wire.foundation/ · 2026-09-03 02:41

References:

Fast payout pokies wire transfer australia https://forum.wire.foundation/d/1567-is-mobile-wire-transfer-casino-australia-worth-a-look

makabharat.com · 2026-09-03 05:16

References:

Payid online pokies australia https://makabharat.com/forum/topic/choosing-online-pokies-payid-deposit/

https://hub.fernekes.com · 2026-09-03 15:42

References:

Bpay pokies online casino https://hub.fernekes.com/t/bpay-deposits-for-online-pokies-what-aussie-punters-need-to-know-in-2026/387

http://forum.lansitec.com/t/sofortuberweisung-casino-beste-seiten-im-test-2026/61 · 2026-09-03 22:01

References:

Casino sofortüberweisung bonus http://forum.lansitec.com/t/sofortuberweisung-casino-beste-seiten-im-test-2026/61

Australian online casinos that take MiFinity · 2026-09-04 03:42

References:

Trusted MiFinity casinos Australia https://bling.pholce.com/forum/topic/mifinity-casino-australia-2026-aud-limits-payouts/

Trustly Casinos Deutschland · 2026-09-04 08:27

References:

Casino ohne Anmeldung Trustly http://forum.lansitec.com/t/trustly-casinos-schnelle-zahlungen-und-klare-vorteile/63

$10 neosurf deposit casino australia · 2026-09-04 08:44

References:

Neosurf live dealer casino australia https://www.mrcp.ac.in/forum/topic/best-neosurf-casino-sites-australia-2026-top-neosurf-casinos/

MP3 Tag Editor · 2026-09-05 11:14

hmm not the tutorial casually setting root’s password to 123456 AND host=’%’ 💀 that’s speedrunning a security incident fr, tho the lower_case_table_names=1 tip is lowkey clutch. meanwhile I’m procrastinating my own db setup with MP3 Tag Editor lol… so who else’s first mysql password was 123456?? be honest 👀

BPM Detector · 2026-09-05 11:15

oh man, digging that random root password out of .mysql_secret at 2am — been there, felt very silly, haha. these days when a terminal fight wears me down i just pause and put on some music (this BPM Detector thing’s been my little sanity save lately), but tell me — anyone else forget the flush privileges line and panic for a solid hour?