Select Code to Download

C:> perl -V:myuname
myuname='Win32 strawberry-perl 5.32.1.1 #1 Sun Jan 24 15:00:15 2021 x6
+4';

C:> perl -MDBI -MDBD::mysql -le "print join qq(\t), $DBI::VERSION, $DB
+D::mysql::VERSION"
1.643   4.050

> .\bin\mysql_install_db.exe --datadir=data
Running bootstrap
...

> start bin\mysqld.exe --console
(opens in new window: shows port 3306)

MariaDB [(none)]> CREATE USER pryrt@localhost IDENTIFIED BY 'password'
+;
Query OK, 0 rows affected (0.015 sec)
...

MariaDB [(none)]> quit
Bye

> bin\mysql -u pryrt -ppassword test_db
... logged in okay, and quit...

> perl -MDBI -le "print DBI->connect('DBI:mysql:database=test_db', 'pr
+yrt', 'password');"
DBI::db=HASH(0x36eca40)
...
C:\usr\local\apps\MariaDB.Portable
> perl -MDBI -le "print DBI->connect('DBI:mysql:database=test_db', 'pr
+yrt', 'passwordx');"
DBI connect('database=test_db','pryrt',...) failed: Access denied for 
+user 'pryrt'@'localhost' (using password: YES) at -e line 1.