All Questions

Tagged with
-1
votes
0answers
22 views

Problem with MySQL: “Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'”

I'm having trouble starting MySQL. When I use the sudo mysql -u root -p command, it asks for the password and then displays this error: ERROR 1045 (28000): Access denied for user 'root' @ 'localhost'...
0
votes
0answers
9 views

MySQL Replication from older master to newer slave - Unknown system variable 'binlog_checksum', 'SERVER_UUID'

So, here is the master: [04:18] [master ~] # mysql -V mysql Ver 14.14 Distrib 5.5.62, for Linux (x86_64) using readline 5.1 And slaves: [08:37] [slave1 ~] # mysql -V mysql Ver 14.14 Distrib 5.7....
1
vote
1answer
54 views

problem with apt upgrade when install MySQL in Ubuntu 19.4

i trying to install mysql in ubuntu 19.4 but i can't upgrade with sudo apt upgrade this is the output ; astrix@astrix:~/Downloads$ sudo apt upgrade Reading package lists... Done Building ...
2
votes
1answer
297 views

Ubuntu 18.04 LTS: Problem with dependencies installing MySQL 8.0 server

I'm trying to install MySQL on Ubuntu 18.04. To do that, first I have donwload the package with the command: wget -c https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_all.deb And then, run the ...
0
votes
1answer
33 views

Is there a maintainable way to install a recent version of phpMyAdmin on Ubuntu 18.04 [closed]

We use phpMyAdmin on a couple of servers running Ubuntu 18.04. Ubuntu ships with PHP 7.2, the latest phpMyAdmin version from the official repositories is 4.6.6, which is not compatible with PHP 7.2. ...
0
votes
0answers
69 views

installing mysql on ubuntu 18.04, what is root password

I installed MySQL on ubunto 18.04 and it is asking me to root password, but I don't have it. Mysql version is: mysql Ver 14.14 Distrib 5.7.23, for Linux (x86_64) using EditLine wrapper what I ...
0
votes
1answer
270 views

Can access /var/lib/mysql-files but not /home/username/Desktop/temp?

I'm using mysql workbench to export my mysql database table to a .csv file using the statement. SELECT * INTO OUTFILE '/var/lib/mysql-files/temporary2.csv' FIELDS TERMINATED BY ',' OPTIONALLY ...
0
votes
1answer
51 views

Which program creates the /etc/mysql directory and its contents?

I was trying to install mysql-server and while trying to set a password I messed up the debian.cnf file and then deleted /etc/mysql hoping that dpkg-reconfigure would recreate it. Now dpkg-...
0
votes
1answer
230 views

Why can't I connect to mysql remotely?

I need to configure mysql so I can connect to it remotely. Here is part of /etc/mysql/my.cnf file: [mysqld] # # * Basic Settings # user = mysql pid-file = /var/run/mysqld/mysqld.pid socket ...
-2
votes
1answer
62 views

How to install MySQL on Ubuntu with a particular IP address on a particular port?

How do I install MySQL on ubuntu 14.04 with the bind address as a particular IP address on port 1723?
-1
votes
1answer
280 views

Cronjobs doesn't work but commands works [duplicate]

I have to command in my cronjob list. I for mysql backup, one for directory cp command. When I run commands, They work. But When I run command the below, I get error: run-parts /etc/cron.daily ...
0
votes
1answer
158 views

Copying MySQL Database via FTP (FileZilla, Ubuntu, Zabbix)

I have recently discovered that we are not backing up our Zabbix database and i was wondering if it is possible to take a backup via FTP on FileZilla by essentially copying the files from the mysql ...
0
votes
2answers
830 views

Ubuntu 16.04 libmfhdfalt.so.0 is missing

I tried both install Mysql Workbench using .deb package and apt. Always returns the same error when launching it. I tried uninstall and install it again back and forth and the same error occurred. ...
3
votes
5answers
22k views

error processing package mysql-community-server during apt-get upgrade

How can I solve this problem? root@ip-*******:/# apt-get upgrade Reading package lists... Done Building dependency tree Reading state information... Done Calculating upgrade... Done ...
1
vote
1answer
565 views

Fun with Ubuntu 16.04 and mysql [closed]

I want to thank you in advance if you manage to get all the way through this post and give me some ideas. It's a lot. I am on Ubuntu 16.04 on a 64bit Dell 1820. It is dual boot with Windows, and I'...
0
votes
1answer
685 views

Where is the BASEDIR for MySQL installed with APT on Ubuntu?

According to the MySQL document, 2.10.1 Initializing the Data Directory: Change location into the top-level directory of your MySQL installation, represented here by BASEDIR: shell> cd ...
0
votes
1answer
38 views

Unable to type character “n” in ubuntu command line interfaces (R, mysql, python,…)

I am having a maddening problem which I hope someone has seen. I am working on ubuntu, remotely over putty. In the shell console, either bash or tcsh, everything is fine. Everything is also fine ...
0
votes
1answer
417 views

Slow response of server

I have a local development server in the local network. There are many instances of magento sites running there. Developers work a 5-6 different magento's and when there is such use the server ...
1
vote
1answer
569 views

How to setup MySQL with cloud-init?

How can I do this? #cloud-config users: - name: dev ssh-authorized-keys: - ssh-rsa AB3NzaC1yc... sudo: ['ALL=(ALL) NOPASSWD:ALL'] groups: sudo shell: /bin/bash packages: - ...
1
vote
2answers
2k views

Cannot login root user after upgrading MySQL from 5.6 to 5.7

After upgrading MySQL from 5.6 to 5.7, I am not able to log in as root: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) I found the following in the log: 2016-10-...
0
votes
1answer
138 views

ODBC Authentication with .pem files on Ubuntu server with Python

Using the below 3 PEM files I am able to connected successfully to a MySQL database on windows threw setting up a Data Source. (No problems here) client-key.pem client-cert.pem ca-cert.pem But I ...
1
vote
0answers
35 views

plesk mysql reporting different version in cli to a version query

I'm trying to upgrade a Plesk server running Ubuntu (12.04.2 LTS) and when doing a query check on apt-cache: apt-cache policy mysql-server ... it reports that I have the latest 5.5. branch already ...
0
votes
1answer
549 views

Couldn't connect to Larvel homestead database with MYSQL workbench

I am unable to connect to laravel homestead via mysql workbench here is how i connected Homestead Connection http://simple.harry.zone/linux/homestead_connect.png but i am facing the below issue ...
3
votes
2answers
4k views

Is the difference between mono-runtime and mono-complete related to whether MySQL inserts successfully take place on Ubuntu 16.04?

What is the difference between 1. sudo apt-get install mono-runtime and 2. sudo apt-get purge --remove mono-complete followed by sudo apt-get install mono-complete on an Ubuntu linux 16.04 instance? ...
1
vote
1answer
939 views

PHP does not use MySQL default sockets

I am having a hard time understanding why PHP cannot connect with localhost as a host. I can connect by doing: mysql -uroot -p And also, through Sequel Pro I can connect with localhost as a host. ...
0
votes
2answers
91 views

How to automatically feed two arguments to program after startup? [duplicate]

I have this following script which works fine on ubuntu for starting and creating a new table for MySQL database: echo "CREATE DATABASE database_name" | mysql -u root -p After this command is ...
1
vote
0answers
141 views

Systemd: Running a script before msyql stops on shutdown

On my Ubuntu 14 vagrant box I use this upstart script to run automysqlbackup on every vagrant halt: description "run automysqlbackup" start on stopping mysql task exec automysqlbackup So ...
1
vote
1answer
1k views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I am trying to copy data from CSV to mysql using shell script where I am all new. And I am working with my test server. mysql -u root -proot csv_imports -e "LOAD DATA INFILE '/var/www/html/$...
2
votes
1answer
3k views

mysql-server-5.5 unmet dependencies each time running apt-get

Each time I run "sudo apt-get install package-name", the following error happened, even if I tried to install other packages other than mysql ones: You might want to run 'apt-get -f install' to ...
2
votes
1answer
298 views

How Remove permission denied with GRANT USAGE ON mysql

I have a mail server in my ubuntu instance. I have a webserver management FROXLOR and i recieve errors for access denied when i try to login in mail account. The log for this: Aug 16 03:14:33 email ...
1
vote
0answers
346 views

Unable to install mysql-server-5.6

My website was running fine on server version 5.5, but now it hangs on the installation of version 5.6. I've tried removing it, purging it, even removing the /etc/mysql folder, then reinstalling it ...
0
votes
2answers
1k views

Cannot Access LAMP Web Server on Ubuntu Server 14.04

UPDATE: So it seems that I can access the website from computers outside of the LAN, it's when I try to pull up from any computer on the same LAN as the server that I get an issue. From what I've read ...
0
votes
2answers
647 views

Ubuntu mysql reinstall service status not working

I tried to reinstall my mysql server on ubuntu 14. After reinstall all seems to run fun until the service mysql status/start/stop command When the server is started the mysql status is stop/waiting ...
8
votes
1answer
18k views

Permission denied writing to mysql log

I am just testing out a new Ubuntu (Vivid 15.04) install on Vagrant, and getting problems with mysql and logging to a custom location. In /var/log/syslog I get /usr/bin/mysqld_safe: cannot create /...
1
vote
1answer
598 views

Unable to access another server over local network on Digital Ocean

I have two servers. Let's call them A and B. Both are running ubuntu server 14.04. B runs percona server. Now I do not have any firewall set-up on either servers still I am unable to connect to server ...
0
votes
1answer
771 views

Mysql exited with status 1 and restarted every 24 hours? How to debug?

After upgrade, MySQL on Ubuntu 14.04 keeps crashing and is restarted every 24 hours according to the dmesg. I would expect to some reason for the failure in MySQL logs, but all are empty. Any ideas ...
0
votes
1answer
1k views

How to move mysql database and mysql server to another machine

I am having Ubuntu 14.04 desktop in which i develop software. Due to some reasons my hard disk has developed many bad sectors. I want to move my mysql server software and all the databases to a new ...
0
votes
2answers
938 views

Respawn MySQL on Ubuntu? Server ran out of memory, killed MySQL & Apache, MySQL didn't respawn

Just as above, I increased the RAM (it's a VM), but that doesn't give me a safety net. I was under the impression by default it should respawn, but that doesn't seem to be the case. *Ubuntu 10.04 ...
0
votes
2answers
915 views

Is there any way to install MySQL 5.1 and PHP 5.3 on Centos 7

Is there any way to install MySQL 5.1 and PHP 5.3 on Centos 7. I researched a lot but could not find any link which gives step by step procedure. Can someone please give me steps to be followed to ...
2
votes
0answers
923 views

How to properly install Apache, MySQL, and PHP on Ubuntu 10.4

I have followed a guide on how to install Apache, MySQL, and PHP on my laptop running Linux (Ubuntu 10.4) It appears I have it installed correctly but when I am not sure. I followed this guide here: ...
1
vote
2answers
792 views

Shell: How to uninstall all related packages to a specific one? / Ubuntu

Recently I asked to my hosting provider to reload the OS to Ubuntu 12.04 64 bit minimal assuming minimal would have the minimum required packages installed, but I realized that mysql was installed so, ...
1
vote
2answers
949 views

Ubuntu: where add a script executing SQL on machine start?

Each time Ubuntu is starting I need to run a script, which is running some SQLs. So I need run it after MySQL already started. Where should I put such script?
15
votes
2answers
21k views

Installing mysql-server in vagrant bootstrap shell script (how to skip setup?)

I did try to install mysql-server on my Vagrant Ubuntu 12.04 LTS virtual machine. When I did so, the setup auto-starts. I can see this in the Vagrant output: While not mandatory, it is highly ...
0
votes
3answers
2k views

mysqldump should prompt for password

When I'm executing mysqldump command from localhost or from remote host, it's not prompting me for password. I want the password prompt even though I'm running it from remote or from local. On my ...
4
votes
1answer
6k views

MySQL server won't install to a new os (Debian, Ubuntu)

Today I wanted to install (on a new VPS with new OS) a MySQL server. I used this command: apt-get install mysql-server mysql-common mysql-client-5.5 I tried with Debian 7 (x64 and x86) and Ubuntu ...
0
votes
2answers
2k views

Cannot apt-get - Package install issue

I was halfway through updating my machine when it crashed and I had to reboot. It was updating new packages while it crashed. When I try to use apt-get it always fails because of a mysql package. ...
3
votes
1answer
2k views

Is it possible to import vmail folder from old iRedMail to new iRedMail installation?

Basically, what I did: Copied vmail folder to my local machine. Reinstalled my VPS. Installed iRedMail again. Created same users on the same domain. Question is - can I somehow copy over my old ...
-1
votes
2answers
406 views

Copyed mysql files from previous system now error while connect, what to do?

Fist of all I have the files but the old system is gone. I took the folders in /var/lib/mysql/ and gave then the permissions the mysql folder that was in there had. user mysql group root only ...
0
votes
1answer
3k views

Connecting from OpenVPN Server to MySQL Server

I have an OpenVPN server installed on a server. What I'm trying to do connect from the OpenVPN server using the mysql client to the MySQL server than is connected to the OpenVPN server using a client....
1
vote
4answers
709 views

MySQL server on Ubuntu fails to start after changes made to my.cnf in Windows

I have MySQL 5.5 running on Ubuntu Server 12.10. When I run /etc/init.d/mysql restart, I get the following: mysql start/running, process 2754 However, when I open /etc/mysql/my.cnf in Windows via a ...