You are not logged in.

#1 2021-02-27 22:19:22

andrewtc4
Member
Registered: 2021-02-27
Posts: 2

What am I doing wrong in setting up MySQL?

EDIT: solved (for now, it seems): So I just tried

mysql -u root -p

again, and for some reason it worked. I think it had to do with copy-paste issues. I keep the root password in a password manager that requires me to copy-paste, and I briefly didn't have access to my mouse for pasting the password into the terminal properly

----

I'm currently taking an introductory databases course in college, and we're using MySQL. I had MariaDB installed and it was working fine, but we've gotten a partner project and my partner mentioned having some issues with an SQL schema I wrote. I thought maybe it's because I'm using MariaDB, as I found out from this page that MariaDB does not appear to have full compatibility with MySQL 8.0, which I assume the rest of the class is using. Okay, I thought, I'll install the AUR mysql package then.

I've got the package installed, and I ran

doas mysqld --initialize --user=mysql --basedir=/usr --datadir=/var/lib/mysql

. I got this warning

[MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.

but otherwise it seemed fine. I enabled and started the mysqld service and have confirmed that those succeeded.

However, when I run `mysqld -u root -p` and enter the temporary password I got, I see

mysqld: Can not perform keyring migration : Invalid --keyring-migration-source option.
2021-02-27T22:09:42.052003Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2021-02-27T22:09:42.052041Z 0 [System] [MY-010116] [Server] /usr/bin/mysqld (mysqld 8.0.23) starting as process 115487
2021-02-27T22:09:42.053499Z 0 [Warning] [MY-010091] [Server] Can't create test file /var/lib/mysql/mysqld_tmp_file_case_insensitive_test.lower-test
2021-02-27T22:09:42.053503Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
2021-02-27T22:09:42.053667Z 0 [Warning] [MY-010122] [Server] One can only use the --user switch if running as root
2021-02-27T22:09:42.053703Z 0 [ERROR] [MY-011084] [Server] Keyring migration failed.
2021-02-27T22:09:42.053733Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-02-27T22:09:42.053819Z 0 [System] [MY-010910] [Server] /usr/bin/mysqld: Shutdown complete (mysqld 8.0.23)  Source distribution.

What have I missed or done incorrectly?

Also, I tried setting up MySQL on my dual-boot Win10 partition, but that gave me other hassles, and I'd rather not have to switch between OSes.

Last edited by andrewtc4 (2021-03-01 16:52:08)

Offline

#2 2021-02-27 23:41:18

WorMzy
Forum Moderator
From: Scotland
Registered: 2010-06-16
Posts: 11,787
Website

Re: What am I doing wrong in setting up MySQL?

Mod note: Moving to AUR Issues.


Sakura:-
Mobo: MSI MAG X570S TORPEDO MAX // Processor: AMD Ryzen 9 5950X @4.9GHz // GFX: AMD Radeon RX 5700 XT // RAM: 32GB (4x 8GB) Corsair DDR4 (@ 3000MHz) // Storage: 1x 3TB HDD, 6x 1TB SSD, 2x 120GB SSD, 1x 275GB M2 SSD

Making lemonade from lemons since 2015.

Offline

Board footer

Powered by FluxBB