Questions tagged [mysql5]
mysql-5 : Version of MySQL Starting with MySQL 5.0
46
questions
1
vote
1
answer
1k
views
Want to install MySQL 5.7 but apt-cache policy mysql-server not showing mysql 5.7 on Ubuntu 22.04
I have some trouble on installing mysql 5.7 on ubuntu 22.04
I follow this steps https://computingforgeeks.com/how-to-install-mysql-on-ubuntu-focal/
I checked that I have followed correctly, but on the ...
0
votes
1
answer
266
views
Number of processes on server
I am bit worried about the number of processes on my server. I see plenty apache and mysql processes after a reboot. I am worried they will start eating up too much resources and bring the server ...
0
votes
1
answer
60
views
Avoiding duplicate MySQL queries in different processes
Is there a way to configure MySQL to avoid two or more identical queries at the same time? e.g. a user generates a report and enters the same page again and generates the same report. The processlist ...
1
vote
0
answers
957
views
Root MySQL Access denied even after resetting root password
I know there are a ton of threads on similar issues where people can't connect using root and need to reset their password to regain access, but in my case resetting the password is not a problem. I ...
0
votes
1
answer
165
views
DATEDIFF() refuses to run on a MySQL Event
I want to create an event that will run every day and see if an account soon expires. The soon_expires cell will be later used by a Bash script that sends an e-mail to related user informing him of ...
0
votes
0
answers
75
views
How to install MySQL 5.7.18 in Ubuntu machine?
I need to install MySQL 5.7.18 in an Ubuntu machine, the apt repo and official MySQL site shows only the version 5.7.24
0
votes
1
answer
35
views
MySQL Group By Issue
I'm having some issues with the group by clause changes in MySQL 5.7. I keep getting an error indicating that I need to fix some queries to allow it to run correctly. I have followed a few different ...
3
votes
1
answer
3k
views
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 :: ...
1
vote
1
answer
369
views
ownCloud migration failed with upgrade from 10.0.0.4 to 10.1.0
After migrating ownCloud to another server, I am attempting to run an update. When running occ upgrade, the the upgrade ends with the following error message:
2019-04-29T22:23:22+00:00 Doctrine\DBAL\...
0
votes
1
answer
52
views
What password to give here?
Before asking my question, i want to tell you background of my problem. I installed MYSQL workbench 8.0. When i first installed it then it was working fine but then I installed xamp, when i started ...
0
votes
1
answer
101
views
Arch+KDE, connect to MySQL server in local container?
I'm running Manjaro/Arch with KDE, which uses MariaDB. I need to use MySQL specifically, so I have created a local container running MySQL 5.7. However, I cannot seem to connect to the instance ...
5
votes
2
answers
355
views
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 ...
2
votes
1
answer
431
views
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 ...
0
votes
1
answer
219
views
Unable to install MySQL after accidentally installing mariadb
I have tried a complete removal of everything (I even backed up and removed databases) each install comes with a different error; either my.cnf has MARIA DB at the top or dpkg has a config issue ([...
4
votes
2
answers
5k
views
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 ...
2
votes
1
answer
601
views
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 ...
3
votes
2
answers
14k
views
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 ...
2
votes
0
answers
835
views
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....
9
votes
3
answers
5k
views
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 ...
1
vote
1
answer
2k
views
Clear screen for MYSQL command line client 3
I tried many of the commands clear the screen in mysql command line on windows but not working...
commands are
clear screen;
cl scr;
cls;
system clear;
system clear screen;
ctrl + l;
tell me the ...
0
votes
2
answers
7k
views
Services don't have MySQL Server. How to run it?
I need to run MySQL Server on a new for me laptop. There's Windows 7. And MySQL have been installed on it. In order to verify this, I opened the Programs and Features window and saw it there:
But ...
16
votes
3
answers
45k
views
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: @@...
0
votes
2
answers
544
views
Mysql-server Error
I install all package on virtual machine.I have centos 6.6 and I already installed "mysqld Ver 5.6.24 for Linux on x86_64 (MySQL Community Server (GPL))".I have installed the tuleap on centos 6.6....
0
votes
1
answer
232
views
Can't start mysql server after macports installation
150213 16:12:31 mysqld_safe mysqld from pid file /opt/local/var/[hostname].local.pid ended
150213 16:21:09 mysqld_safe Starting mysqld daemon with databases from /opt/local/var
150213 16:21:09 [...
0
votes
1
answer
6k
views
MySQL server: Error 1067 (in services.msc) and Error 10061 (in mysqld console) - what troubleshooting may be attempted?
I'm trying to install MySQL Community edition on a Windows 8.1 machine. To sum up the problem: whith the .msi installer I get MySQL registered as a service, but unable to start (error 1067); with a ...
1
vote
3
answers
1k
views
Show All Results From One Table Not Listed In The Other (Junction) Table By :id
I have 2 tables I'm interacting with.
The first table: acl_permissions (is just a normal table).
+-----------------------------------+
| acl_permissions |
+----+-------------+------...
5
votes
3
answers
45k
views
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.
...
1
vote
0
answers
668
views
After logging into MySQL 5.6 successfully as root, it says access denied for root, ERROR 1045 (28000)
I recently used MacPorts to upgrade from MySQL 5.5 to 5.6. I can use my database fine on my laptop. I tried to enable remote access to the database so I could edit the database using DB clients on ...
0
votes
1
answer
302
views
How to backup MySQL databases when the MySQL server is off?
My MySQL server does not start, as according to the guides I found over the internet, the best solution is to re-install MySQL server (with apt-get purge). However, this process will delete my ...
0
votes
2
answers
8k
views
How to remove few tables from a large SQL file?
I have a SQL file with size around 3 GB. So this takes some long time to restore every time when i took recent dump from production.
In this one table 'access_log' itself took 2.2 GB which is just a ...
0
votes
1
answer
11k
views
Cannot connect to mysql server using IP Address
I am trying to connect to mysql using an ip, but I am getting this error:
ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (111)
I can connect using localhost instead of an ...
0
votes
0
answers
1k
views
Raspberry Pi: mvoe home & var folders to USB HDD?
I have a Raspberry Pi running raspian. I've installed Apache2, PHP & MySQL. Apache & MySQL are both configured to use sub-directories of /var. I'd like to use a directory on my USB HDD ...
0
votes
1
answer
592
views
Ubuntu 10.04 to 12.04, mysql5 causes upgrade hang
I'm doing a release update from 10.04 to 12.04. The upgrade process walked me through all the conflicting .conf files and I chose to keep my version of mysql.conf. Despite that, the upgrade process is ...
1
vote
2
answers
3k
views
MySQL cannot recognize variable on file option
I'm using MySQL 5.6 on Mac OS X 10.8 and trying to configure mysql to log genreral_log into a file. However, it always throws an error when I start it.
Here is the .my.cnf file looks like (located at ...
1
vote
1
answer
665
views
Using Mysql Replicate to replicate at a particular time
My job has a testing, staging and production enviroment. They want most database changes to be done on the staging environment and for the production environment to replicate the staging environment. ...
0
votes
0
answers
106
views
Configuring the mysql server
I have a mysql server installed in RHEL 6 system with 128 GB of Ram and 16 Cores. i am running 4 websites with quite heavy queries having big joins and sortings. Please suggest me a good configuration ...
1
vote
2
answers
5k
views
mysqld will not start
This is the error I get when attempting to start the mysql server:
# mysqld start
130105 8:51:28 [Note] Plugin 'FEDERATED' is disabled.
130105 8:51:28 InnoDB: The InnoDB memory heap is ...
3
votes
1
answer
8k
views
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-...
2
votes
0
answers
525
views
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 ...
0
votes
1
answer
334
views
Why does rsnapshot not back up /var/lib/mysql/*?
In rsnapshot's config file I added /var/lib/mysql/ as another source directory to back up.
But rsnapshot does not back it up. Why?
/var/log/rsnapshot does not list a relevant warning.
The owner of /...
9
votes
3
answers
6k
views
\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 ...
0
votes
2
answers
4k
views
Mysql stopped working
Mysql is up and running on my system but i can not login with any user. I also cannot start/stop/status the server. All i got is:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using ...
5
votes
2
answers
36k
views
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 ...
1
vote
1
answer
97
views
How to retrieve all MySQL settings?
I have a configured MySQL server (MySQL 5.1.47-community) that works perfect. I installed a second server (MySQL 5.5.15-community) to see if the new version of MySQL would work with my application ...
0
votes
1
answer
90
views
Alternate installer for MySQL v5.5?
I tried to install MySQL v5.5 on my PC, but it won't install on my machine.
Is there another installer that contains MySQL v5.5 that I can try, preferably not the official one from http://www.mysql....
8
votes
9
answers
27k
views
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 ...