Super User
Super User

Questions tagged [mysql5]

mysql-5 : Version of MySQL Starting with MySQL 5.0

46 questions
16
votes
3 answers

Import MySQL data failed with error 1839

I have master slave setup of MySQL with GTID configured. I took back data backup of master and importing it to individual Test server. It is failing to import as ERROR 1839 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set…
JAVAC
  • 263
9
votes
3 answers

MySQL instance lost when upgrading to Windows 10

I had a running instance of MySQL 5.6 in my Windows 8.1. After upgrading to Windows 10, such instance is gone, including the Windows service for it. Server data files are however intact. What would be the best way to recover or re-create the exact…
Jago
  • 315
9
votes
3 answers

\G like vertical output in MySQL Workbench for show engine innodb status

show engine innodb status; is unusable in MySQL Workbench, as shown here: =====================================120329 12:39:32 INNODB MONITOR OUTPUT=====================================Per second averages calculated from the last 17…
KCD
  • 500
8
votes
9 answers

Configuring a MySQL 5.1 Instance on Windows 7 Professional x64 Fails

I'm trying to set up my laptops to function as mobile development environments. Installing the software on my Linux machine and getting it configured was fairly straightforward, however I'm having trouble getting MySQL 5.1 Server installed and…
Thomas Owens
  • 3,904
6
votes
3 answers

How can I get MySQL workbench to always show the result grid?

When I execute a SELECT query in the MySQL workbench, the result grid appears. Then, when I execute an UPDATE, the grid disappears. Then when I run a SELECT again to view the changes, it reappears. This is incredibly annoying and causes the screen…
asteri
  • 474
  • 3
  • 6
  • 14
5
votes
2 answers

Can't connect to MySQL server on 'localhost' (10061), but can via PHP

With WAMP 2.2 serving Apache 2.2.21, MySQL 5.5.16 and PHP 5.3.8 on my Windows XP development machine, I can connect and manage my database via phpMyAdmin or any locally hosted PHP script using a DNS like "mysql:host=localhost;dbname=kwamjing" When I…
JannieT
  • 1,231
  • 8
  • 20
  • 31
5
votes
2 answers

Plesk using outdated password for MYSQL5.7

I'm unable to login to my Plesk control panel, or even pull up the page. Plesk's repair utilities fail to work, so web/GUI methods seem to be entirely unavailable. The only way I can login is via command: mysql -u admin -p [entering correct…
user10902472
  • 83
  • 5
4
votes
2 answers

How to upgrade mysql server in windows?

I am attempting to upgrade MySql server from version 5.6 to 5.7. After installing MySql server 5.6, I proceed to upgrade it by launching the installation wizard through .msi file of MySql5.7. It detects the existing server(5.6) on the system and…
RishabhK
  • 51
3
votes
1 answer

Can't start MySQL5.5 on Ubuntu 12.04 - “dpkg: dependency problems”

This appears to be a common problem on 12.04. I've tried everthing in this thread including: sudo apt-get clean sudo apt-get autoclean sudo apt-get remove --purge mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server mysql-server-5.5…
Archonic
  • 132
  • 1
  • 6
3
votes
1 answer

How to upgrade Windows MySQL Server 5.7.26 to 8.0.16?

I am having trouble upgrading from MySQL Server 5.7.26 to MySQL Server 8.0.16. Maybe it's just because I'm not a seasoned DBA, but to me the MySQL reference manual is quite vague. From MySQL :: MySQL 8.0 Reference Manual :: 2.11.10 Upgrading MySQL…
BrotherCreamy
  • 31
3
votes
2 answers

where is the my.cnf file for mysql server located on windows?

I'm running MySQL Server 5.6 on Windows 7 and would like to enable slow query logging. Unfortunately, it is not immediately obvious to me where the my.cnf file is. I see C:\Program Files\MySQL\MySQL Server 5.6\my-default.ini but according to…
neubert
  • 7,574
  • 39
  • 94
  • 156
2
votes
0 answers

Who should I run mysql as, on a personal computer?

I just installed mysql via homebrew (with brew install mysql, on Mac OS X Mountain Lion - recently installed from scratch). Following the installation, there is a "caveats" section with options around further necessary actions to take: ==>…
user664833
  • 856
2
votes
1 answer

MySQL 5.7.17 running on Linux Mint (can't start mysqld_safe --skip-grant-privileges

Accidentally erased MySQL 5.7.17 (linux) privileges for root. I can still login as root. Just can't do much. I've searched web for days looking for way to start mysql_safe --skip-grant-privileges but none of the suggestions work. An article in…
Dave Henzler
  • 21
2
votes
1 answer

Steps to install php mysql on centos 6.8

I have a server with centos 6.8 I am trying to install php 5.5. mysql 5.5 php-mbstring But it shows error message as: Error: php55w-common conflicts with php-common-5.3.3-48.el6_8.x86_64 Please tell me step by step guide to install.
Francis
  • 21
2
votes
0 answers

upgrading to MySQL 5.7 from 5.6

I downloaded MySQL Installer 5.7.10, thinking it'd update the version of MySQL I have from 5.6.27 to 5.7.10 and... it doesn't seem to be able to. I could manually backup my databases, uninstall 5.6.27, install 5.7.10 and then restore the databases,…
neubert
  • 7,574
  • 39
  • 94
  • 156
1
2 3 4