Questions tagged [mysql5.6]
42 questions
0
votes
0 answers
broken packages when installing mysql 5.6 using apt-get
I am trying to install mySql 5.6 on my Linux machine.
I tried
>apt-get install mysql-server-5.6
but I am getting the following error:
mysql-server-5.6 : Depends: mysql-common (>= 5.6.22-1~) but 5.5.50-0+deb8u1 is to be installed
…
special0ne
- 101
- 2
0
votes
2 answers
MySQL Wont Start with Datadir Change
I'm trying to change the datadir for mysql. When I try to restart the service it hangs for 10 minutes, then fails to restart. Here are the steps I took to change the dir:
sudo service mysqld stop
sudo cp -R -p /var/lib/mysql /srv/msqyl2
ls -lha…
chris85
- 81
- 2
- 11
0
votes
3 answers
Install mysql-5.6 non interactive
I couldn't find any solutions how to install mysql-5.6 in a docker container non-interactively. I found the following commands but they need user input:
# Update the repo list, execute :
wget…
tester
- 109
0
votes
1 answer
MySql ignores memory settings
I'm using MySql community server 5.6 on Ubuntu 15.04, I have /etc/mysql/my.cnf (no other config files). I've made changes to it and restarted MySql. When I use such query
SELECT @@key_buffer_size
(or some other config from my.cnf file) it returns…
heroin
- 101
- 3
0
votes
1 answer
XtraBackup restore gives duplicates on slaving?
We've recently upgraded a MySQL 5.0 master-master setup to Percona 5.6. Slaving went b0rken due to some failures on our side, but we thought we could simply fix it by using xtrabackup to create a backup from the running server and importing it to…
Tim Stoop
- 588
- 5
- 20
0
votes
0 answers
MySQL server has gone away: Two APIs, single database, One API throws the error while other doesn't
I have two flask restful API's. Both are working fine.
API1 is only for reading the database, API2 deals with update/insert. Both access the same database.
Problem:
API1 stops working every morning and I have to restart it everytime (once in the…
Mr.President
- 1
- 1
0
votes
1 answer
How to upgrade mysql5.5 to 5.7
I have a MYSQL Server 5.6 on ubuntu 14.04, having more than 2000 databses.
Now we have to upgrade it to MYSQL version 5.7. Kindly let me know how can i take backup of this huge data & upgrade process.
Hoping for earliest response
03amittrivedi
- 19
- 1
- 1
- 3
-1
votes
1 answer
Dropping all mysql databases using ssh
I am totally new to the ssh so pardon if I commit any mistake.
Well, I have had 457 databases which i wanted to take backup and put databases in individual files. Which i got a working solution from this Answer. Now I have dumped all the databases…
Aitazaz Khan
- 101
- 4
-1
votes
1 answer
Can't log in MySQL with newly created user, but any username without password is accepted
I installed MySQL 5.6 on Windows, imported a database (as root), and created a new user with a password to access this database.
Connexion with the username and password does not work (tested with Workbench).
However, if I connect without password,…
youen
- 209
- 2
- 6
-1
votes
2 answers
Ubuntu - Some one is able to write on ubuntu/apache server
Someone is trying to hack my website, I have a website built on PHP (7)/MySQL in Laravel framework. The owner of the /var/www is www-data and folder permission is set 700 for all folders and file permissions are set to 600. Still, the hacker is able…
Krishna
- 1
-3
votes
1 answer
How to find the MySQL database table data directory when it's different from the global one
When creating a new table, I specified the data directory with:
CREATE TABLE t2 (c1 INT PRIMARY KEY)
TABLESPACE = innodb_file_per_table
DATA DIRECTORY = '/alternative/directory';
How can I find the data directory of this table later?
If I do…
asvignesh
- 117
- 1
- 7
-3
votes
1 answer
Mysql downgraded from 5.7 to 5.6, and now it stops immediately after startup
I have a digital Ocean droplet on CentOS 7. I had installed 5.7 in the beginning, but I wanted to use 5.6 for some reason. So I just removed 5.7 using yum remove, and then after disabling 5.7 from yum. Then I enabled 5.6 and installed it. But since…
vishal dharankar
- 97
- 1
- 4