Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mysql]

Questions regarding the MySQL database server, client and tools.

0
votes
0answers
11 views

fetching problem while installing mariadb

(Click image to enlarge) I need help in installing mariadb server for mysql.
1
vote
0answers
15 views

Access denied 403 phpmyadmin in xampp

I relaunch this issue: I can't make xampp access to phpmyadmin. I did all the configurations required yet the access is always denied. here is my htppd-xampp.conf file #<IfDefine PHP4> #...
0
votes
0answers
16 views

ERROR: Database files are locked. Daemon already running?

Every time I use apt-get upgrade or install mysql always report its errors. Can anyone help me to resolve this problem? Thanks& regards. ERROR: Database files are locked. Daemon already running? ...
0
votes
0answers
10 views

preview the data from a exported .mysql file without loading into MySQL

What I want to do is preview an exported SQL file without having to load it into the MySQL server. Many of my exported or backup files have the same names, but different dates and locations. In simple ...
0
votes
1answer
18 views

After running for few days if mysql gives following error

After running perfectly for few days, If the mysql server gives following error. mysql -uroot -p -h localhost Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '...
0
votes
1answer
46 views

MariaDB installation error: Unable to correct problems, you have held broken packages

I am trying to install MariaDB following the official site but I keep getting errors. First step: $ sudo apt-get install software-properties-common Reading package lists... Done Building dependency ...
0
votes
0answers
13 views

How to use the galera-3 package correctly in Ubuntu 18 LTS?

apt-get install galera-3 mysql-server is successful and creates /usr/lib/galera/libgalera_smm.so, but show status like 'wsrep%' returns nothing. When I put wsrep_provider=/usr/lib/galera/...
0
votes
0answers
42 views

Is it possible to install mysql 5.6 in ubuntu 18.04

I also follow the link to install 5.6 Install mysql 5.6 on Ubuntu 18.04 LTS but it not working in my case I Also install mysql 5.6 for ubuntu 18.04 sudo apt-get install software-properties-common ...
0
votes
0answers
44 views

LAMPP MySQL Ubuntu not running

I have an issue when I restart mysql server : via the following : /opt/lampp/var/mysql$ sudo /opt/lampp/lampp start Starting XAMPP for Linux 5.6.36-0... XAMPP: Starting Apache...already running. ...
0
votes
2answers
62 views

'Can't connect to local MySQL server through socket '/path/mysql/mysqld.sock' (2 “No such file or directory”)'

After I have changed the datadir of my MariaDB (Ubuntu 16.04), I cannot restart mysql anymore. I changed the path of the data directory in the /etc/my.cnf file. But if I try to start MariaDB with ...
0
votes
1answer
25 views

how to save mysql queries automatically when a query is executed using command line terminal?

what I am trying here is, I want to save mysql queries and output of that queries in a file and also to show on the ubuntu terminal. My approach is like this: $ mysql -u user -pmysql |& tee day1....
0
votes
0answers
15 views

MySQL partition /var/lib/mysql is full BUT it is not full 1

i receive this error when i try to connect mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
0
votes
1answer
32 views

Permission Mysql Ubuntu 18.04

I have a problem. I install on my ubuntu 18.04.1 lamp server + phpmyadmin. And run existing site (locally). Main page working good. But all another pages return 404. I get this site from windows (...
0
votes
1answer
39 views

Can't update mysql without system root password set

I am trying to update the system but mysql 5.7 is failing. It appears that it cannot connect due to authentication issues. Here is the full console output: Reading package lists... Done Building ...
2
votes
1answer
21 views

mysql “jammed” into every install although I don't want it

[Ubuntu 16.04] I don't have mysql running on my machine, not do i want it. I do need to install redis-server. so I did this: $ sudo apt-get install redis-server E: dpkg was interrupted, you ...
0
votes
0answers
19 views

How to enable MySQL's query log for non super user separately?

I know it can be done for super user by giving general_log=1 and setting general_log_file location, but i want to give separate log location for normal user, is there any way to do it?
0
votes
0answers
33 views

Mysql bin.log file rotation

I am trying to change the binary log rotation from days to hours. By default there is an option only for days in mysql config file: expire_logs_days. Is there any way, where i could change binary log ...
0
votes
0answers
14 views

Error when restarting mysql

i run: sudo service mysql restart and i get this: Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for ...
0
votes
0answers
31 views

phpmyadmin showing php code 18.04.1 LTS

I am attempting to setup phpmyadmin on my Linux Ubuntu 18.04.1 LTS Dedicated Server but seem to be running into an issue of the page displaying plain PHP Code, i have looked on google and attempted ...
0
votes
0answers
19 views

Backup script for mysql [duplicate]

I would like to write a bash script containing next command: mysqldump -u root -p moodle > moodle_sql_backup_21_08_2018.sql I added #!/bin/bash but then I get stuck with two problems: -p ...
0
votes
1answer
19 views

how to make a new account on mysql server?

I setup mysql wrong and I don't know how to change the usr/pass to get on to it. Please can somebody help me because I am new to mysql and don't know how to do this
0
votes
2answers
44 views

how to reconfigure mysql-server

I want to setup mysql-server again but I am not sure how to do it. I have tried sudo dpkg-reconfigure mysql-server but it does not do anything. output of ps aux | grep mysql: matthew 9288 0.0 ...
0
votes
0answers
31 views

Error when re installing mysql-server

i removed mysql-server because i set it up incorrectly. When i try to install it now i get this error matthew@matthewserver:~$ sudo apt-get update Hit:1 http://archive.ubuntu.com/ubuntu bionic ...
1
vote
0answers
48 views

Where is useSSL=false located?

I recently got this error: Thu Sep 27 23:12:40 CEST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ ...
1
vote
1answer
38 views

How to execute mysql commands in sh

I try to write a script, which create database and tables in it. For example, my bash file create attempt: #!/bin/bash mysql -u root -p use dbname; create...... ....... exit; Is executed joining ...
5
votes
1answer
127 views

mysql not starting after removing plasma-desktop

I know there are many questions regarding mysql not starting. I've tried following things Checking MySQL error log — error reading '/var/log/mysql': Is a directory Check /var/log/dist-upgrade/apt....
0
votes
0answers
31 views

Manual install of mySQL 5.7 fails Ubuntu16.04.4

I'm doing a manual install of MySQL but it does not complete, The error message is below. If it does not work in manual install I doubt it will work when I set up a shell script for the install. ...
0
votes
1answer
45 views

Connect to mysql localhost

In my new Ubuntu 18.04 I can't connect to mysql, from local host: mysql -u root -p Enter password: ERROR 1698 (28000): Access denied for user 'root'@'localhost' I uninstalled and reinstalled mysql ...
0
votes
1answer
25 views

impoting binary file to mysql

i have binary files .fo and .ibd for a database and i want to import them to mysql .. what i did ? backup mysql folder: cp -a /var/lib/mysql /var/lib/mysql-backup copy database folder from old ...
-1
votes
1answer
36 views

after setup ssl phpmyadmin not working [closed]

aim using amazon Linux before setup ssl ip/phpmyadmin its working i am using ssl for lets-encrypt sudo certbot --apache use this command and add ssl for my all web sites now when i type ...
0
votes
0answers
37 views

Mysql Server stopped working

i tried sudo service mysql start it gave me: "Failed to start mysql.service: Unit mysql.service not found". and /etc/init.d/mysql start which gave me "/etc/init.d/mysql: No such file or directory" ...
0
votes
0answers
37 views

How to fix MySQL reinstallation failure in the Ubuntu 14.04 LTS?

I've tried removing and installing MySQL several times and I always get the same message: Do you want to continue? [Y/n] Y Setting up mysql-server-5.5 (5.5.61-0ubuntu0.14.04.1) ... start: Job failed ...
0
votes
1answer
33 views

mysql reinstallation still getting problems ubuntu

Renaming removed key_buffer and myisam-recover options (if present) mysql_upgrade: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) while connecting to the MySQL server ...
0
votes
0answers
42 views

Can't import database through terminal

I am trying to import database through terminal but nothing happens. Literally. No errors just - root@toma-hp-zbook-17:/var/www/html/elite-core# mysql -u root -p elite-core < elite-core.sql Enter ...
0
votes
0answers
392 views

PhpMyAdmin, Access denied for user 'root'@'localhost'

I'm using ubuntu 2018, I have just installed phpMyAdmin but I get this message: #1698 - Access denied for user 'root'@'localhost' I have followed this steps: Cannot enter phpmyadmin as root (MySQL ...
0
votes
0answers
21 views

Which mysql-server is my server using? [duplicate]

I have ubuntu 14.04 on my aws ec2 instance. I ran following command to find out the mysql-server installations and I got multiple results : dpkg --get-selections | grep mysql Now I would like to ...
0
votes
0answers
56 views

The following packages have unmet dependencies. mysql-workbench-community [duplicate]

You might want to run apt-get -f install to correct these. The following packages have unmet dependencies. mysql-workbench-community : Depends: libcairo2 (>= 1.15.8) but 1.14.6-1 is installed ...
0
votes
0answers
71 views

My server index.php is showing a blank page

I have managed to set up my server and upload my first php code to see if the server is working, and it is. PHP 7.0.30-0ubuntu0.16.04.1 (cli) (NTS) mysql Ver 14.14 Distrib5.7.23, for Linux (x86_64)...
1
vote
0answers
27 views

No config files for mysql / mariadb-server

I have a problem on one server running Ubuntu 18.04. I have no idea, but the server does not generate config files for the mariadb-server. The /etc/mysql directory does not exist after the ...
2
votes
0answers
71 views

Windows Server 2012 Putty Connection Network error: Connection refused + Not Access to Ubuntu [closed]

I got a Virtual Private Server with Windows Server 2012 Operation System. Now I want to install and config MySQL and PHP and Apache on my server. I found a tutorial and tutorial use Putty for ...
0
votes
1answer
422 views

Remove/re-install LAMP with current versions on Ubuntu 18.04

I'm having trouble with my LAMP stack since the Ubuntu 18.04 upgrade, so I'd like to just remove everything and start with a clean slate. I'm referring to the post entitled "How do I remove the LAMP ...
0
votes
0answers
19 views

Ubuntu connection refused randomly during the day

I have a server with Ubuntu 18.04. I have installed Apache2, Mysql Server, Mailcow Dockerized, openssh. Sometimes the server is refusing every connection and i dont know why. The Apache server is ...
0
votes
1answer
65 views

Problem while install mysql in ubuntu 18.04

I am trying to install mysql in ubuntu 18.04. I used the command apt-get install mysql-server but it did not ask for root password while installing. I referred to the solution on this question but ...
0
votes
1answer
44 views

Cannot enter safe mode or set mysql root password new install ubuntu 18

I have tried reinstalling nothing seemes to help $ sudo mysqld_safe --skip-grant-tables & [1] 8688 $ 2018-09-04T20:51:49.362162Z mysqld_safe Logging to syslog. 2018-09-04T20:51:49.365443Z ...
0
votes
0answers
54 views

mysqld: Can't create directory '/opt/mysql/mysql/data/' (Errcode: 13 - Permission denied)

I have a problem with mysqld When I call mysqld --initialize-insecure --console --datadir=/opt/mysql/mysql/data --basedir=/opt/mysql/mysql --user=mysql I get this error: mysqld: Can't create ...
0
votes
0answers
19 views

Failed writing body while installing Sql [duplicate]

enter image description hereI've installed Ubuntu and Virtual Machine on my Mac OS and I'm trying to download Sql now and run into this error when I use this command in my Mac terminal. curl​​ https:/...
0
votes
0answers
17 views

Botched my Nginx install, making it worse

having an issue. Trying to do Owncloud install and Nginx is not working. Followed directions, but I missed something is all I can come too. Here is what I have from my /etc/nginx/sites-enabled/defualt....
0
votes
0answers
28 views

Apache2 wont start, error code

New to ubunutu, installed mysql for Kodi and configured, now I am working on Owncloud and as I am working through install, Apache doesn't want to play nice. Here is journalctl -xe results: -- Unit ...
0
votes
1answer
25 views

I can't found mysql in /etc/init.d folder

● mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) Active: active (running) since Fri 2018-08-31 18:03:37 KST; 9min ago ...
0
votes
2answers
306 views

Can't run phpmyadmin on Ubuntu 18.04

I have installed apache, mysql and phpmyadmin on my Ubuntu 18.04 but whenever I open http://localhost/phpmyadmin this is what i get <?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * Main ...