Setting up MySQL in UwAmp

[Xozz]

Hi. I'm trying to set up an AMP system on my machine. It's called UwAmp. Anybody there to tell me how to setup the MySQL in this thing? Thank you

[rproffitt]

Tell us what you mean by setup. I see UwAMP already packed in MySQL.

WampServer refers to a solution stack for the Microsoft Windows operating system, created by Romain Bourdon and consisting of the Apache web server, OpenSSL for SSL support, MySQL database and PHP programming language. Wikipedia

[Xozz]

WIth set up I mean install ;)

[Xozz]

Addition: If you know a better (W)Amp package, tell me.

[rproffitt]

http://www.uwamp.com/en/ shows it has MySQL. I can't guess how you installed it or what options. See the image at
http://www.uwamp.com/en/images/screen_1.png and right there is where you select which MySQL you want.

[Xozz]

I get this error when I open phpMyAdmin

#1045 Cannot log in to the MySQL server

[rproffitt]

Ahh, maybe you forgot to set and config the password in MySQL and phpMyAdmin?

https://www.google.com/search?&q=phpmyadmin+config+mysql+password finds many priors so I stop here.

[Xozz]

I found a WAMP-package that works better now. The only problem is that phpMyAdmin gives an error when I run a .sql file.

Fout (error)

SQL-query:

/!40101 SET NAMES utf8mb4 /;

MySQL retourneerde: Documentatie (MySQL returned: Documentation)
#1115 - Unknown character set: 'utf8mb4'

What should I do?

[rproffitt]

Find out which MySQL you have and read https://www.tutorialspoint.com/how-to-resolve-the-error-1115-42000-unknown-character-set-utf8mb4
That tutorial shows how to show the version and character sets.

[Xozz]

I feel like a big noob right now... I'm just trying all different WAMP-programs and I haven't succeeded yet. Is there a WAMP-program that you would advise?

[rproffitt]

Not really. While I have used a few WAMPs and LAMPs, all have me configure MySQL and the other items. I get the feeling you want the WAMP to do all this for you but that's not really possible since any decent MySQL must have us setup users and passwords. Otherwise folk might install such things without any security.

Again, all the WAMPs and LAMPs I've used over the years worked fine but not one has us skip learning how to configure.

[john_111]

I've used USBWebserver for years, which has zero installation, just place it on your hrd disk or usb drive if you want to move from computer to computer and use it.
https://www.usbwebserver.net/webserver/
But has has been suggested, if all else fails, RTFM