6
votes
Accepted
MySQL instance lost when upgrading to Windows 10
You can manually put the service back as follows:
STEP 01) Open the Windows CLI as Administrator
STEP 02) cd C:\Program Files (x86)\MySQL\MySQL 5.6\bin or wherever mysqld.exe resides
STEP 03) ...
- 3,075
5
votes
Accepted
Plesk using outdated password for MYSQL5.7
Pointers for updating the Plesk MySQL password
According to the "The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication" post, you can go to Plesk > Domains > ...
5
votes
Import MySQL data failed with error 1839
If you are like me and you don't want to re-run your dump because it was a very long operation you can just remove those lines after the fact.
find . -name '*.sql' -type f -exec perl -0 -i.bak -pe 's/...
- 181
3
votes
Accepted
where is the my.cnf file for mysql server located on windows?
Here's the location with MySQL Server 5.7:
C:\ProgramData\MySQL\MySQL Server 5.7\my.ini
- 6,919
3
votes
Plesk using outdated password for MYSQL5.7
Following the instructions on a link shared by Pimp Juice's answer, Typing plesk db gave me the error: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
The ...
- 83
2
votes
Import MySQL data failed with error 1839
I have a huge database, so, like @Goddard,
I have a backup/dump spread across several files.
I have low disk space,
so I export my dump in compressed format (i.e., .sql.gz).
@Goddard's solution ...
- 121
2
votes
Accepted
DATEDIFF() refuses to run on a MySQL Event
CREATE EVENT check_expire
ON SCHEDULE
EVERY 1 DAY
STARTS '2019-08-21'
DO
UPDATE users
SET soon_expires = (DATEDIFF(expirationtime, CURRENT_DATE) < 45);
or
UPDATE users
SET soon_expires = 1
WHERE ...
- 3,195
1
vote
MySQL instance lost when upgrading to Windows 10
All you need to do is reconfigure your current server. A nice step by step tutorial including screenshots can be found here, you do like this:
First, open the application MySQL Installer – Community ...
- 211
1
vote
Accepted
Unable to install MySQL after accidentally installing mariadb
Try
Use sudo apt-get purge instead, to remove config files as
well.
https://askubuntu.com/posts/147281/edit
- 2,008
1
vote
How to upgrade mysql server in windows?
From what I can tell, the MSI based installer will let you upgrade the minor versions but not the major. So you can update 5.5.xx to a newer 5.5.xx but not to 5.7. It seems to want to create multiple ...
- 145
1
vote
Steps to install php mysql on centos 6.8
to remove the previous install
yum remove php-common-5.3.3-48.el6_8.x86_64
this was suggested on another forum:
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm
rpm -...
- 80
1
vote
How can I get MySQL workbench to always show the result grid?
Go to Mysql Workbench preferences.
In Fonts, change de Resultset Grid font to Arial 11.
Its works for me.
- 11
Only top scored, non community-wiki answers of a minimum length are eligible