Questions tagged [mysql]
Questions regarding the MySQL database server, client and tools.
2,948
questions
3
votes
0
answers
3k
views
libmysqlclient.so.16
I have a program I'm trying to get running on an Ubuntu machine (I've previously run it only on CentOS), and when executing it I get:
error while loading shared libraries: libmysqlclient.so.16: ...
8
votes
4
answers
45k
views
Unable to install mysql-workbench for Ubuntu 16.04 LTS
I looked around the several answer but none solved my problem.
First, I tried sudo apt install mysql-workbench -f.
It shows
The following packages have unmet dependencies: mysql-workbench :
Depends:...
- 228
1
vote
0
answers
2k
views
MySQLi extension is missing
I see this message when go to http://localhost/phpmyadmin/
MySQLi is commented out in php.ini (php7.0 is used by apache)
Command 'php -m' in terminal shows that mysqli is installed, so why it is ...
- 11
3
votes
2
answers
7k
views
How to provide a password while executing `mysqldump` through shell script
I wrote a batch file which establishing the connection to linux server which I am able to do so, after this I am trying to take the mysqldump to some certain directory, it has all 777 permissions but ...
- 33
3
votes
2
answers
35k
views
unknown variable 'bind-address=ip'
I was trying to run some mysql command, but then when I run it, this happens
mysql: unknown variable 'bind-address=[ip]'
Stuff looks different in my.cnf:
[mysqld]
bind-address = [ip]
port = 3306
...
- 834
2
votes
1
answer
3k
views
Unable to update nor remove MySQL after updating Ubuntu
two days ago I updated my server to the Xenial version and for some reason it totally broke my MySQL configuration. So, I tried to update it, remove it, and as it didn't worked I tried many ideas I ...
- 185
0
votes
1
answer
528
views
Database backup
I want to take backup of Xampp database available in /opt/lampp/var/mysql
`but I am unable to do it.
I used below command
/opt/lampp/htdocs/vivek.s$ sudo mysqldump -u root -p vive.se >
07feb....
- 336
0
votes
1
answer
2k
views
Installing Mysql group replication plugin
When I give
INSTALL PLUGIN group_replication SONAME 'group_replication.so';
command in mysql, I get the following error
And when I navigate to the directory, there is no package named ...
0
votes
0
answers
36
views
mysql server or client
Why mysql server or client is not in software selection. It looks like the only way to install mysql is using sudo apt install command.
- 951
1
vote
1
answer
2k
views
How do I use PAM with MySQL (on Xenial)?
I am running Ubuntu 16.04 and installed libpam-mysql and pamtester. To test out the module, I tried running the following command:
pamtester --item user=X --item passwd=X --item host=127.0.0.1 --item ...
- 185
0
votes
1
answer
281
views
Need help! How to export mysql database from a system os drive, that is not running
I had a web server running on an hdd, ubuntu 16.04, on an LVM. I did mount the LVM in my Ubuntu workstation, to pull off the website an realised that i didn't export the mysql database yet, now it won'...
- 341
1
vote
1
answer
4k
views
Xampp: cannot connect to mysql from terminal
I added export PATH=$PATH:/opt/lampp/bin/ to my ~/.zshrc file. I can access php but whenever I type sudo mysql -uroot I see the following message:
ERROR 2002 (HY000): Can't connect to local MySQL ...
- 439
2
votes
1
answer
3k
views
mysql_connect error
I've executed the below command in sublime text editor
mysql_connect('localhost','root','');
And got the below error:
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /opt/...
- 21
0
votes
0
answers
1k
views
mysql restore from dump backup of all databases with user privileges
I have read so many tutorials and tried so many things.
I have a single sql file of all databases backed up with mysqldump (50+).
When I try to restore the databases using root account - they ...
- 196
2
votes
1
answer
3k
views
Automysqlbackup not working with 16.04 Xubuntu when mysql.user set plugin = 'mysql_native_password'
Intro
I installed automysqlbackup via the apt packager manager via sudo apt install automysqlbackup.
Issue
sudo automysqlbackup worked fine with 14.04 but starting with 16.04, it doesn't work ...
- 345
1
vote
1
answer
1k
views
MySQL fails to restart on Ubuntu 17.10
I'm following this guide:
http://kodi.wiki/view/MySQL/Setting_up_MySQL#tab=Ubuntu_Linux
The aim is to use mysql network file sharing so that I can view the media on my Raspberry Pi OSMC on Kodi ...
- 51
4
votes
1
answer
611
views
what to do when mysql command tool does not allow to enter Cyrillic alphabet?
After upgrading Ubuntu from 16.10 to 17.10 I have a problem.
Now the mysql command-line tool does not allow to enter Cyrillic alphabet.
When you start the mysql command tool, you can write SQL ...
- 61
1
vote
1
answer
2k
views
How do I install one or more versions of MySQL and switch between the versions when I need?
I have a development machine built on Lubuntu. Now, I have a requirement to test the code on various PHP and MySQL versions. Switching between PHP versions is not a problem. But my main problem is to ...
2
votes
1
answer
12k
views
invoke-rc.d: could not determine the current runlevel
I uninstalled MySQL because I was having a problem with the root user password not working. Now I can't reinstall. I've tried reading through some similar posts but frankly they're beyond my level or ...
- 21
6
votes
3
answers
41k
views
#1698 - Access denied for user 'root'@'localhost' mysql -5.7 and ubuntu-16.04
I am getting below error while logged into the phpmyadmin.
it is not a fresh installation.
I have also tried login through the command line.
1.
mysql -u root -p
**error :** ERROR 1698 (28000): ...
- 271
1
vote
1
answer
2k
views
Should I run sudo mysql_secure_installation after installing mysql?
I just installed mysql. I need to know should I run this command:
sudo mysql_secure_installation
and after installing it.
-1
votes
1
answer
444
views
bash script with mysql insert into - do other on duplicate entry
I have a mysql table with some unique constraints.
I have a script that asks some questions, and then inserts the answers into the mysql table.
I don't know how to tell the script to do something ...
- 95
1
vote
1
answer
601
views
MySQL Server won't start
Something seems to have happened with MySQL server (MariaDB dropped-in). If there is any needed information that I have not provided, please specify.
$ sudo service myql start
Failed to start myql....
- 11
3
votes
4
answers
14k
views
MySQL Ubuntu 16.04 not starting
I have tried to open Mysql in Linux Ubuntu 16.04 but I got an error:
ilqar@ubuntu:~$ mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/...
4
votes
2
answers
31k
views
WARNING: Module mcrypt ini file doesn't exist under /etc/php/7.2/mods-available
I've been trying to install phpmyadmin in Ubuntu 16.04.3 LTS having a lamp installed, php 7.2, mysql Ver 15.1 Distrib 10.2.12-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 and apache2.
...
- 153
2
votes
1
answer
12k
views
Error MySQL: ERROR 2002 (HY000): Can't connect to local MySQL server through socket (Ubuntu 14.04.5)
mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
service mysql status
mysql stop/waiting
service mysql restart
stop: Unknown instance:
...
- 21
1
vote
1
answer
7k
views
Creating database access denied
Here is what I've done:
user@name /my/path # mysql -u root -p<myPassword>
mysql> create database spy;
ERROR 13 (HY000): Can't get stat of './spy' (Errcode: 13 - Permission denied)
How can ...
- 581
0
votes
1
answer
2k
views
How do I turn off the sql server by default on startup? [duplicate]
As soon as I turn on my system and run the command :
service mysql status
It shows that the service has been activated since the PC was turned on, I want it to be off my default and when I want to, ...
- 123
2
votes
1
answer
2k
views
Adding config file entries to specific sections
I am trying to write a script that configures mySQL. Let's say I want to configure the port to 3333, so I want the config file to contain the lines
[mysqld]
port=3333
[client]
port=3333
At first, I ...
- 4,617
0
votes
0
answers
63
views
How to remove LAMPP packages? [duplicate]
Used this question to install LAMPP:
What's the easiest way to set up a LAMP stack?
Several problems have cropped up and I want to start over. How can I remove everything?
Tried the suggestions ...
- 563
1
vote
0
answers
223
views
Do I have two or more different setups of MySQL/MariaDB?
I've had a kind of annoying problem quite a while now. I run a Ubuntu 16.04 LTS Server for my own company at my own home. I also run a mariadb-server on this server, but a big problem is that when I ...
0
votes
2
answers
333
views
MySQL unmet dependicies
I tried installing MySQL-Workbench and I get the following errors. How do I solve them?
isaac@isaac-HP-Laptop-15-bs0xx:~$ sudo apt update && sudo apt upgrade
[sudo] password for isaac:
Hit:1 ...
- 123
0
votes
1
answer
2k
views
MySQL Workbench and Unmet Dependencies. Solution? [duplicate]
I am trying to install MySQL Workbench through the System Settings and I get the following error:
The following packages have unmet dependencies:
mysql-workbench: Depends: libgcc1 (>= 1:3.0) ...
- 123
0
votes
0
answers
325
views
Unable to uninstall MySQL 5.7 from Ubuntu 16.04 [duplicate]
I have the following results
$ sudo apt-get install -f
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be REMOVED:
mysql-...
- 123
4
votes
4
answers
27k
views
mysqldump a zipped dump
Till now I've created and zipped mysql dumps this way:
mysqldump -u root -p --all-databases > /var/www/html/db-$(date +\%F-\%T).sql
zip /var/www/html/db-$(date +\%F-\%T).zip /var/www/html/db-*.sql
...
0
votes
1
answer
3k
views
Set MySQL default time zone to UTC
I want to set the default time zone of my MySQL install to UTC. My system time zone is Australia/Brisbane, and I want to leave it that way, I just want to set the default time zone for MySQL. I've ...
- 339
0
votes
1
answer
587
views
MySQL 5.6 installation issue in Ubuntu 14.04
I had MySQL 5.5 and I tried variety of ways to upgrade to MySQL 5.6 but it didn't work properly.
When I do:
test@test:~$ sudo apt-get install phpmyadmin
[sudo] password for test:
Reading package ...
- 123
0
votes
0
answers
339
views
only one site on server says PHP is missing MySQL extension (nginx)
I have a Ubuntu 16.04 server with Nginx as webserver. When I try and access one of the sites installed, I receive this error:
"Your PHP installation appears to be missing the MySQL extension which ...
0
votes
1
answer
115
views
Is there 2 options to install mysql? and Have Ubuntu decided to maintain up to date mysql with the latest version in his 16.04 Xenial repositories?
I have installed mysql from the official ubuntu repository, runing this commands.
sudo apt install mysql-server
Even you can install mysql-workbench. And this is the version, and yes it is the ...
- 1,824
0
votes
0
answers
318
views
Access PHPMyadmin in Ubuntu
I installed the LAMP stack [Apache2, Mysq, PHP] and phpmyAdmin for DB administration. All worked fine except when I open mysql in my terminal, it has different configurations than my phpmyadmin:
...
- 19
1
vote
1
answer
3k
views
Change mySQL datadir: problems with apparmor
I'm trying to change mysql data directory to a zfs dataset.
I've changed mysql.cnf and /etc/apparmor.d/usr.sbin.mysqld, but still have errors. I get the errors even when I try to stop apparmor ...
- 141
11
votes
2
answers
30k
views
mysql -u root doesnt work but sudo mysql -u root does, why?
I recently followed some tutorials and installed mysql using
sudo apt-get install mysql-server-5.7
I can connect to the database using password by running the following command:
sudo mysql -u root -...
- 237
0
votes
0
answers
557
views
How can I restore the apparmor settings for /var/lib/mysql?
I had to stop the mysql service, blow away the /var/lib/mysql, then recreated it with a copy of /var/lib/mysql from a remote server. Such reckless action was in order to ... "import"? ... a really ...
- 502
0
votes
2
answers
17k
views
Files Permission with nginx [closed]
I'm new on the web server world, so please bear with me.
I'm trying to build my own API for mobile application using Ubuntu, Nginx and Lumen.
Everything was going fine till I came to upload images ...
- 103
0
votes
1
answer
3k
views
MySQL: Suddenly connection error without making any changes
I'm running MySQL 5.6.30 - MySQL Community Server (GPL) on ubuntu-16.04-x86_64 and I'm using phpMyAdmin 4.7.7.
Sometimes, without doing anything on the Server or phpMyAdmin, I'm getting this error ...
user776951
0
votes
1
answer
5k
views
Using the mysql-db python connector
I was finally able to install the connector as shown below:
How to connect to MySQL db from python 3 on 16.04
I include the result of the install at the end.
However when I try to use the connector ...
- 415
5
votes
3
answers
34k
views
How to connect to MySQL db from python 3 on 16.04
I am following this guide so that I can can install the MySQL connector for python 3.
https://stackoverflow.com/questions/43501080/how-to-connect-to-mysql-db-from-python-3-on-ubuntu-16
Unfortunately ...
- 415
1
vote
1
answer
407
views
I wrecked my server: best way to move forward?
As I said, my server is wrecked. Not entirely, just partially.
I have a headless server running Ubuntu 16.04, and can reach it over SSH (and FTP via ssh port).
On it, I have a modded minecraft server ...
- 149
0
votes
0
answers
359
views
Problems installing mySQL server on 16.04 [duplicate]
I'm having problems intalling mySQL server on 16.04.
I tried:
sudo apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
You ...
- 415
2
votes
0
answers
2k
views
Unable to uninstall mysql-community-server
I'm trying to remove mysql-community-server, but it gives me this:
sudo apt-get remove --purge mysql-server mysql-client mysql-common
Reading package lists... Done
Building dependency tree
...
- 121