New answers tagged mysql
0
votes
Upgrade mysql 5.6 to 8 not working on AWS Linux based EC2
Oh deer!?! You don't want to upgrade your database infrastructure this way.
GOODNESS!
So many people have had an issue doing this. It almost always turns out icky. I cannot possibly urge you enough. ...
0
votes
Upgrade mysql 5.6 to 8 not working on AWS Linux based EC2
Upgrading from MySQL 5.6x to 8.x is not supported... You'll need to upgrade MySQL to 5.7.9 first, then from that version you should be able to upgrade to 8.x
https://dev.mysql.com/doc/refman/8.0/en/...
2
votes
Upgrade mysql 5.6 to 8 not working on AWS Linux based EC2
It could be that you are running Amazon Linux 1.0, that version doesn't support systemd.
So I think you might need to upgrade the os first before you can upgrade myswl
0
votes
Low performance with mariabd and zabbix
I would let atop run on a certain interval to get an overall insight into the performance of the server.
Atop can capture performance snapshots of the compute resources like memory,CPU,disk and ...
0
votes
Accepted
Mysql Error 1045 Access Denied: Using Password: FALSE
A little embarrassed to say, but the issue was fixed by turning the website off and on again. I apologize because I realize this isn't too helpful.
Since I don't usually work with websites, I got used ...
2
votes
Accepted
Why does MySQL server not respect bind_address?
The quote from the documentation you linked:
If the address is *, the server accepts TCP/IP connections on all server host IPv4 interfaces, and, if the server host supports IPv6, on all IPv6 ...
0
votes
MariaDB using more memory than expected
3/1/2024 stepping stone AG
This is likely contributing to your problem.
https://stackoverflow.com/questions/78071133/mariadb-not-releasing-ram-after-jobs-finish
Global Variable SELECT @@...
1
vote
MySQL errors after reinstalling
There's open bug on this:
https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1897381
Associated: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1612517
Fixed:
I know this old, but here'...
1
vote
Accepted
Why did our AWS Aurora RDS spike and lock up?
SELECT thisstuff ( thistime ) AS thestuff , COUNT ( * ) AS count
FROM mytable
WHERE todo = ?
AND someID = ?
AND ( ( FIND_IN_SET ( otherID , ? ) ) ||
( FIND_IN_SET ...
0
votes
MySQL connection works with localhost but not with 127.0.0.1
it worked for me in linux.
edit the file - /etc/mysql/mysql.conf.d/mysqld.cnf
make it like this -> bind-address = 0.0.0.0
Refer - https://phoenixnap.com/kb/mysql-remote-connection
Top 50 recent answers are included
Related Tags
mysql × 8726linux × 1007
php × 748
ubuntu × 693
database × 531
apache-2.2 × 468
mariadb × 462
centos × 442
mysql-replication × 398
innodb × 362
debian × 265
amazon-web-services × 251
backup × 246
performance × 232
replication × 226
amazon-ec2 × 190
sql × 171
amazon-rds × 152
wordpress × 146
windows × 135
nginx × 130
security × 125
permissions × 122
postfix × 119
memory × 119