Skip to main content

New answers tagged

0 votes

MySQL: Converting Row to Columns Based on Field Values

Recreating your dataset with: create table test ( PKey bigint primary key, attr1 varchar(10) not null, attr2 varchar(10) not null, data1 int not null, data2 int not null, RecCreated ...
FloT's user avatar
  • 427
0 votes

Move mysql databases to external drive on MAC OS (dealing with the absence of my.conf file)

this was working for me since 2021. Recently Tried to upgrade my SQL to version 8.4 but with the more modern password system would not work the software I needed to use Tried down grading to 8.3.0. ...
E Baron's user avatar
0 votes

MariaDB --tc-heuristic-recover in Docker container

Or in a file .yml (docker-compose) can be given the command: services: mariadb: command: --tc-heuristic-recover=ROLLBACK Before that, I deleted the tc.log (because I also had an error ...
Николай Гобанов's user avatar
0 votes
Accepted

keep getting mysqli_real_connect(): (HY000/1045): Access denied for user 'testing'@'localhost' (using password: YES) for non-root users

First you need to create a username specifically like 'testing'@'localhost' Then you need to do a grant all privileges on database_name.* to 'testing'@'localhost'; If you are on the same machine ...
cybernard's user avatar
  • 14.2k
4 votes
Accepted

How to Import MySQL 4.1.14 data into MySQL 5.7.44?

Have you tried (on a copy of the files of course) something like https://github.com/andrebossi/mysql4 or https://github.com/Tommi2Day/mysql4 just to get a dump? Actually, it might actually even work ...
jcaron's user avatar
  • 1,903
8 votes

How to Import MySQL 4.1.14 data into MySQL 5.7.44?

There are still sites that have MySQL 4.1.x, such as Japan Advanced Institute of Science and Technology, which has v.4.1.21 downloads for various operating systems. That version is likely compatible ...
DrMoishe Pippik's user avatar
0 votes

phpMyAdmin cannot login - keeps asking for credentials

Something that worked for me was going into my shell, and opening MySQL with the root user mysql -uroot. Since I have never opened it in this PC before (I migrated from Ubuntu to Windows) it prompted ...
GNU Jesus's user avatar

Top 50 recent answers are included