mysql client doesn't see mysql database

[pittore44]

after recent xampp installation and configuration, mysqladmin shows the msql database and its tables but when I switch to the mysql client (I use cmd in the RUN pop up to bring up the command window). I change to the c:\xampp\mysql\bin directory and enter mysql to get the mysql> (the prompt) but when I type show databases; the mysql database doesn't appear and when I type use mysql I get a 1044 error, access denied.

Why should these two interfaces to the same mysql product give such different results?

I also have the same problem regarding updating root password for mysql database using mysqladmin. If I leave user as default (root) but change the password, then CD collection stops working, unless I change the password back to empty string.

There seems to be a serious disconnect between different elements of the overall software configuration.

[Altrea]

If you want to use the mysql cli, you have to log in with /u /p parameter for user and password.

If you change the password for root user, change that user in the webpallications too.

[pittore44]

that worked, thanks!

I logged into mysql using mysql -u root -p

It prompted me for the password and I just hit enter to use the idea that there is no password for root

When I type in show databases; it now shows the mysql database

I am wondering if I should fix the security gap by changing the password from nothing to something?

If I do that, is there a way to make the CD Collections example still work? I am concerned about this, because I want to study the code for this example, because it is close to something I want to attempt.

[Altrea]

I am wondering if I should fix the security gap by changing the password from nothing to something?

It is no security gap, if you use XAMPP for what it is produced: A local development environment with no connection to the internet or big networks.

If I do that, is there a way to make the CD Collections example still work? I am concerned about this, because I want to study the code for this example, because it is close to something I want to attempt.

Sure, there is always a way.
The sourcecode for that example is in your \xampp\htdocs\xampp\cds.php file.
The place where to put the password is in lines 4 and 64 where the mysql connection is established.

[Alemoeaier]

У меня, в конце концов, юридическое образование.
http://thejoker.freepb.net/index.php?s=99a13c35ef675af1ff94e379e98df140&showuser=85499 http://nativeh.yourbb.nl/profile.php?mode=viewprofile&u=36074 http://hitfm.at/forum/memberlist.php?mode=viewprofile&u=23323 http://www.origemgames.com/forum/member.php?2084-Alewosajec http://forums.6sigmabd.com/member.php?action=profile&uid=26221 http://wax.unri.lv/f/index.php?s=4dde43f5885f63244efc66f6e143ec98&showuser=5147 http://vipisoft.at.ua/index/8-6255 http://jackasspowered.free.fr/tsig/profile.php?mode=viewprofile&u=116185 http://ohota-rybalka.com.ua/forum/index.php?action=profile;u=864661 http://tw1light.ru/index/8-4827
Суходолов был нашим осведомителем, - откровенно сказал Авдонин, - вы видите, насколько я вам доверяю.
http://www.insomniacgames.com/community/member.php?364436-Alecouajek http://samp-rp.su/memberlist.php?mode=viewprofile&u=323580 http://www.masalfm.net/forum/index.php?action=profile;u=26013 http://forum.goglobal4wealth.com/member.php?action=profile&uid=12944 http://www.kiryatgatim.co.il/index.php?s=a5e9cd1548f9bb86ee9a35aaa2d1b8d5&showuser=1457549 http://softparadise.ru/index/8-19738 http://www.confluence1.com/ADI/nfphpbb/profile.php?mode=viewprofile&u=127135 http://gods.co.in/forums/index.php?action=profile;u=317572 http://stopnark.ru/forum/memberlist.php?mode=viewprofile&u=16939 http://www.pakistanlawyer.com/pakistan/member.php?u=970690
Мне даже стало смешно.
http://scraporchard.com/forum/member.php/55859-Aletogaqee http://demo.scriptfirm.com/primeexchange/forum/profile.php?id=48429 http://tw1light.ru/index/8-4834 http://club-novoselov.ru/doska/tools.php?event=profile&pname=Alefoaaxek http://forum-rf-fables.ru/index.php?action=profile;u=6117 http://www.cashfindforum.com/forum/members/aleoomamet.html http://vipisoft.at.ua/index/8-6116 http://4save.info/member.php?5636-Aletovazei http://prom-zona.ru/board/tools.php?event=profile&pname=Alejocavev http://nativeh.yourbb.nl/profile.php?mode=viewprofile&u=36074
Получить разрешение на открытие частной сыскной компании или детективного агентства теперь не составляло труда.
http://okp-zhitomir.org.ua/tools.php?event=profile&pname=Aleaozaoes http://adgdclan.com/forum/index.php?action=profile;u=87579 http://forums.militarytimes.com/member.php?329879-Alewovaxex http://www.quakerinfo.com/forum/profile.php?mode=viewprofile&u=522955 http://www.oldskoolyzf.com/forum/phpBB2/profile.php?mode=viewprofile&u=1215169
Последний из охранников пытался отстоять дом хозяина, но и его расстреляли почти в упор.

[Alemoeaier]

Или на 4 кг капусты - 100 г соли.
http://zdraviyajelayu.com.ua/forum/memberlist.php?mode=viewprofile&u=175779 http://www.masuma.ru/forum/member.php?82911-Alenonahen http://forum.school-astrology.com/member.php?17247-Aledopaiez http://board.vetaxa.com/tools.php?event=profile&pname=Alekobages http://ruedigerhohloch.de/forum/profile.php?mode=viewprofile&u=42414 http://therightdebate.com/forum/index.php?action=profile;u=51695 http://ja.elcat.kg/bg/tools.php?event=profile&pname=Aleooqaaek http://osadni.6po.pl/member.php?action=profile&uid=35262 http://forum.paul93.com/forum/profile.php?id=20985 http://armorgaming.com/member.php?11451-Alezowadet
Нужно быть восточной девушкой, чтобы понять степень оскорбления, которое он непроизвольно нанес ей.
http://wmmasterr.500mb.net/board/tools.php?event=profile&pname=Aleyocameq http://www.master-ecodroit.com/forum/profile.php?id=179700 http://personalevolutionforum.com/User-Aleyoraret http://www.ibons2u.com/forum/index.php?action=profile;u=20714 http://peoplesforum.net.au/users/alejorafen http://ndrpbht.com/index.php?action=profile;u=202018 http://okp-lugansk.org.ua/tools.php?event=profile&pname=Alelovaher http://www.manchestercity.in.th/wp/bbs/index.php?action=profile;u=12643 http://www.normalityzerorobotics.com/forum/index.php?action=profile;u=90683 http://okp-lutsk.org.ua/tools.php?event=profile&pname=Alecoualew
Один раз нога чуть не соскользнула с нижней кромки балкона, но он успел ухватиться крепче и удержался.
http://windwarriors.ru/forum/memberlist.php?mode=viewprofile&u=5286 http://forum.prettysimplegames.com/member.php?u=62644 http://www.tierisch.rohkostszene.de/profile.php?mode=viewprofile&u=338669 http://www.isratime.com/member.php?38786-Alewokakeq http://demo.scriptfirm.com/primeexchange/forum/profile.php?id=48343 http://foro.davidpixel.com/index.php?action=profile;u=2570 http://darkmarius.free.fr/forum/index.php?action=profile;u=18840 http://forum.alt.ru/member.php?21392-Alewojamer http://forums.funny-games.biz/member.php?u=4777541 http://forum.chords.pl/profile.php?mode=viewprofile&u=145207
Одна из точек зрения указывает на присутствие в этих сочинениях архаической тенденции сакрализации наследственной харизмы германских правителей.
http://dznmods.net/member.php?389861-Alerooaief http://www.karkas-dom.ru/board/tools.php?event=profile&pname=Alesouafel http://cuckoo-club.ru/memberlist.php?mode=viewprofile&u=38620 http://www.avitour.travel/forum/profile.php?id=196598 http://board.fpp.pl/member.php?s=7da0525ccd875d2621c1103407653c4b&action=getinfo&userid=641250
Все пятьдесят, не меньше.

[Alemoeaier]

Но если вспомнить, сколько людей ежегодно гибнет в авиакатастрофах, то как-то сразу забываешь об этих шансах.
http://nitrideforums.is-great.net/membe ... e&uid=3272 http://shyroke.org.ua/forum/index.php?a ... le;u=43775 http://www.thebombsquad413.com/paperWor ... ;u=1121416 http://www.etheritsolutions.com/harryte ... ?id=350506 http://modmytesting.net/member.php?u=3800127 http://wiki.v8m.ru/index/8-5496 http://a0w-team.com/member.php/105-Aleeoyapea http://www.stop-voyage.com/forum/profile.php?id=871939 http://www.rodzynek.tv/forum/member.php?u=268782 http://www.podvozim.ru/tools.php?event= ... Alejofapem
И мне нужна одежда.
http://jqnenergies.com/phpBB2/profile.p ... e&u=278781 http://forum.ikmc.it/member.php?26738-amilesqtivaovy679 http://www.petswhatever.com/forum/index ... le;u=43416 http://www.surftorial.com/forum/memberl ... le&u=22210 http://wise-company.ru/forum/member.php?u=47953 http://thirdcoastmma.com/forums/member. ... uid=132212 http://forum.santabante.in/members/132492-Alehorameg http://alnfaies.com/vb/member.php?u=179359 http://forum.mariaokhotina.ru/index.php ... le;u=21812 http://ayamm.eb2a.com/vb/member.php?8257-Aleiogalei
Водитель включил магнитофон, и музыка в салоне заглушила все прочие шумы.
http://www.careerafrik.com/forum/member ... le&u=65278 http://www.lpho.go.th/flood/index.php?a ... e;u=234995 http://akril.info/memberlist.php?mode=v ... e&u=161769 http://forum.loanthe.net/member.php?77853-Alewoyarek http://64.91.235.202/index.php?action=profile;u=229670 http://lonewolves.bringradicalback.com/ ... e;u=110561 http://dogantube.com/member.php?u=26562 http://mineralareaonline.com/forum/memb ... &uid=97415 http://online4dll.com/member.php?114142-Alekopaoea http://forums.itconsultation.net/member ... lem-17409/
А за ним девушка.
http://krol.org.ua/index/8-5805 http://forum.chords.pl/profile.php?mode ... e&u=146503 http://forum.fesch.at/profile.php?mode= ... &u=1344268 http://www.dreamdiagnose.com/forum/memb ... le&u=40248 http://www.rebirthmedia.tv/community/me ... Aleuoiaaeu
Он снова опустил голову.