Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
23 views

Installing mysql 5.5, 5.6 and 5.7 on same machine on ubuntu 14.04

Currently i installed mysql 5.5 in my system. If i install mysql 5.6, the system asks for upgrade. sudo apt-get install mysql-server-core-5.6 Reading package lists... Done Building dependency tree ...
3
votes
2answers
4k views

Mysql 5.5 reinstallation 12.04

I had a broken installation of mariadb over mysql 5.5. For hours i have tried to reinstall mysql with the usage of apt-get - tried to purge, remove etc everything mysql related. Uninstalled php ...
1
vote
1answer
2k views

MySQL won't start after removing bind-address

So, I am running mysql on an ubuntu server (command-line) VirtualBox, on a Windows 7 host. In the Virtual machine, I changed the /etc/mysql/my.cnf file by commenting out the line bind-address = ...
0
votes
1answer
23 views

mariadb-server syntax error

I am writing a bash script and having trouble with $PASSWORD. Can anyone please tell me the correct way to write sql lines in bash script? QUERY="GRANT ALL PRIVILEGES ON db.* TO 'user'@'localhost' ...
-1
votes
0answers
16 views

change the password of phpmyadmin in ubuntu

I have installed phpmyadmin and I forget the username and password now I am trying to connect through web browser by typing url :localhost/phpmyadmin. and I am pressing root and password as root it ...
0
votes
1answer
395 views

MySQL Workbench doesn't start

I installed MySQL Workbench from Ubuntu software center and it just doesn't start when I click on it. There's no error shown up. What's the matter? UPDATE: $ mysql-workbench --log-level=debug3 ...
0
votes
0answers
15 views

how-to-install-mysql-5-6 on Ubuntu 12.04

First thing first, I know this question has been asked so many times, I checked all the questions answer before writing here. I want to know how to install mysql 5.6 on Ubuntu 12.04. As I want to ...
1
vote
1answer
25 views

Cannot install phpmyadmin on ubuntu 14.04 LTS

I have installed ubuntu along side with window 10 (dual boot). I have set up apache2 server, mysql and install PHP 7, and then I want to install phpmyadmin I cannot install it. I have try many time, ...
0
votes
1answer
39 views

How To Set Up the Ubuntu 14.* Included X-Windows(xUbuntu) / MySql / PHP (Apache 2 ) In VMware

I had used Linux system for near decade , but now I need to use it again because I want to use more open resources and try to use like DevOpe solutions so that I hope I can give me some notices and ...
1
vote
4answers
67 views

Does Ubuntu 14.04 support PHP, Mysql, Apache?

Versions are: Ubuntu server version is 10.04 PHP version is 5.4.7 Mysql version is 5.1.69 Apache server version is 2.4.3 Now, I would like to update to Ubuntu 14.04 but no update PHP, Mysql and ...
2
votes
2answers
307 views

Is it safe to Install Both Redis and MySQL on the same system?

Mine is a question not on how to install either but on whether I can have both MySQL and Redis-Server on my Ubuntu 12.04 machine. I need both for different projects, any help forthcoming will be ...
1
vote
2answers
2k views

no mysql workbench in ubuntu 12.04 software center

I have already installed MySQL workbench from the Software Center on a recent installation of Ubuntu 12.10 (32 bit) with no problems. Since then, I just installed ubuntu 12.04 LTS on another machine ...
0
votes
3answers
239 views

phpmyadmin not working chrome show error 500 firefox shows nothing

im using ubuntu 16.04 LTS development branch. I have recently installed mysql, apache2 and phpmyadmin. When i enter localhost/phpmyadmin in address bar in firefox it simply show nothing while chrome ...
0
votes
0answers
16 views

Ubuntu 12.04 ODBC connection to MySQL

I have task - write CEL events into mysql. I wrote next setting: odbcinst.ini => [MySQL] Description = ODBC for MySQL Driver = /usr/lib/i386-linux-gnu/odbc/libmyodbc.so Setup = ...
0
votes
1answer
20 views

dpkg: error processing package php5-mysql (--configure):

When installing PHP and mySQL, I got the following error message. What to do? Creating config file /etc/php5/mods-available/mysql.ini with new version cp: cannot create regular file ...
0
votes
0answers
19 views

Cannot start phpmyadmin

I cannot start my apcahe2 and phpmyadmin in my VPS. $ sudo apt-get install phpmyadmin Reading package lists... Done Building dependency tree Reading state information... Done Some ...
77
votes
9answers
172k views

Mcrypt extension is missing in 14.04 server for mysql

The php mcrypt extension on ubuntu 14.04 shows that it is installed properly, but phpmyadmin says: The mcrypt extension is missing. Please check your PHP configuration. My current php config is ...
9
votes
3answers
13k views

MySQL can't open files after updating server: errno: 24

Ubuntu: 12.04 LTS (Linux mysql02 3.2.0-40-generic #64-Ubuntu SMP Mon Mar 25 21:22:10 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux) MySQL: Ubuntu distro 5.5.31 Apparmor: REMOVED! Server has been running ...
0
votes
0answers
22 views

MySql installation error

I am a newbie Ubuntu user. I am using Ubuntu 14.04. The problem is when I try to install MySql using this command sudo apt-get install mysql-server php5-mysql I got this error message. Reading ...
0
votes
1answer
17 views

Need help troubleshooting virtual host

Good day, I maintain system for a non-profit and I'm having difficulty with one of our virtual hosts. I'm stumped as to where the issue is. The server is running Ubuntu 12.04 LTS, it's reasonably ...
0
votes
0answers
24 views

Cannot connect remotely to either MySQL or Postgres

I am trying to connect remotely to the MySQL database on my cloud server which is configured with Ubuntu 14.04.03. However I cannot do so (details below). I can neither connect from a Windows client ...
3
votes
2answers
60 views

Can i put everything back after accidentally doing “apt-get remove mysql-server”?

I have accidentally typed in webserver terminal following command: sudo apt-get remove apache2 php* mysql* -y Can i rescue my database tables, without a backup? I know that, for instance, apache ...
13
votes
5answers
23k views

MySQL 5.5 starts and then instantly stops

MySQL 5.5 on Ubuntu 10.10 used to work well until yesterday but today whenever I start MySQL using mysqld_safe as root user it shows Starting mysqld daemon with databases from /var/lib/mysql and ...
-3
votes
1answer
25 views

My sql password [closed]

I am using command on Mac $ mysqladmin -u root password mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' anyone can help ...
1
vote
3answers
779 views

Reinstall of mysql server hangs

I am trying to reinstall mysql-server-5.5 because mysql server would not start. I purged everything but the install fails I am trying to reinstall using sudo apt-get install mysql-server-5.5 and it ...
1
vote
1answer
8k views

“'Access denied for user 'root'@'localhost'” when trying to do commands

The other day I was using MySQL on my local database fine from the terminal. However, when I rebooted the next day and tried to use it, I get the following error for just about EVERYTHING related to ...
0
votes
2answers
14 views

mysql broke software center, nautilus, and dpkg - nothing installs

Tried to install mysql-server 5.5 and 5.6, then mariadb-server. There is a bug report for mysql-server. Recommended is mariadb. That won't install either. Tried to install synaptic - dpkg errors from ...
2
votes
3answers
24k views

how install mysql 5.6 and mysql workbench 6.0.9 on ubuntu 13.10

I am using Ubuntu 13.10 Saucy Salamander (64 bit System) . I want to install mysql 5.6 and workbench 6.0.9 on it. how i do it please describe step by step?
0
votes
2answers
36 views

how to intstall mysql server on ubuntu

i am using ubuntu 15.10 sudo apt-get install mysql-server output: Reading package lists... Done Building dependency tree Reading state information... Done E: Unable to locate package ...
0
votes
2answers
410 views

Ubuntu 15.10 mysql error 1524 - unix_socket

On Ubuntu 15.10, at a point (maybe after an install & remove of mariadb) mysql was unable to operate. Tasks are up, but the server is down. At the command: mysql -u root -p the system reply ...
3
votes
2answers
4k views

How can I install specific version of MYSQL

I'm trying to install mysql-server 5.0. because I want to install a program which depend on this version. I've surfed the net to find a solution but none of them worked. I'm really disappointed. I ...
1
vote
1answer
73 views

SSD extremely slow when connected with internal SATA, ok with external USB

I have a brand new laptop (Asus N551VW, i7-6700HQ, 16 Gb ram) on which i installed Ubuntu 14.04 64bit and a new Samsung SSD 850 PRO 512Gb (latest firmware). I installed the default MySql 5.6.27 on the ...
1
vote
0answers
73 views

MySQL gradually taking up more and more memory

Just to start with, I have read the following threads and they do not help: Optimising MySQL settings - mysqld running out of memory MySQL Server keep shutting down ...
3
votes
2answers
8k views

mysql not starting

I have a server running on rackspace.com, it been running for about a year (collecting data for a project) and no problems. Now it seems mysql froze (could not connect either through ssh command line, ...
0
votes
3answers
1k views

Installing LAMP - PHP not connecting with MySQL - Why?

Am followoing this amazingly simple LAMP tutorial http://ubuntuserverguide.com/2014/06/how-to-install-lamp-in-ubuntu-server-14-04-lts.html Installing Apache Installing MySQL Installing PHP The ...
0
votes
1answer
14 views

Setup /var/www for two groups

I have two groups. ftpgroup and www-data. I'm using proftpd and mysql to store the ftp users and their homes. When the user registers it creates the folder first and then creates the user account in ...
3
votes
3answers
30k views

The phpMyAdmin configuration storage is not completely configured

I typed apt-get install phpmyadmin and ran into an error saying it cannot connect to mysql (socket issue). It was normal because I forget to install mysql before, so I selected "abort" above all ...
0
votes
0answers
23 views

in XAMMP MySQL Database is stoped

I'm running Xampp on Linux(Ubuntu 14.04) and while everything was working fine until an hour back right after I shut it down it suddenly starts throwing this error. the erreur : MySQL said: ...
0
votes
2answers
4k views

Errors installing php5-mysql extension

Getting error when installing php5-mysql. Looks like a dpkg error. Perhaps a broken package. Have tried to fix the broken package. Have reinstalled the lamp server and everything seems fine except ...
0
votes
0answers
17 views

MySQL Database in XAMMP is stoped

I'm running Xampp on Linux(Ubuntu 14.04) and while everything was working fine until an hour back right after I shut it down it suddenly starts throwing this error. the erreur : MySQL said: ...
0
votes
1answer
4k views

MySQL not starting in Xampp

I am using Ubuntu 14.04 and Xampp 5.6.3-0. I cannot get the MySQL server to run. I have tried executing these commands so far (run in this order): sudo chmod 755 /opt/lampp/etc/my.cnf sudo chmod -R ...
0
votes
0answers
11 views

Installing wordpress removed owncloud sql admin account

I I've been running owncloud (8.2.xx) for a while with no problems. Been using SqLite. The other day I installed wordpress, that runs with MySql. That installation somehow romoved my admin account on ...
0
votes
1answer
6k views

mysql: unrecognized service (apparmor)

Many questions on this point but I couldn't any help yet. Mysql was working then I tried to move mysql database directory as (in this ...
0
votes
1answer
54 views

How can I configure logrotate to SCP multiple log files

I would like to copy multiple files form logrotate, so I try this : /var/log/mysql.log /var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log /var/log/mysql/error.log { daily rotate 7 ...
0
votes
0answers
24 views

what is the solution of Mysql database stoped

I have XAMPP for Linux 5.6.12-0 . When I Start the Xammp , It shows the following : Starting XAMPP for Linux 5.6.12-0... XAMPP: Starting Apache...ok. XAMPP: Starting MySQL...ok. XAMPP: Starting ...
0
votes
0answers
12 views

Mysql Workbench Import Data

Ubuntu 15.10 Using the import data wizard in Mysql Workbench to import 241 records from a csv file resulted in the successful importation of 97 records only. When I tried using another csv file, only ...
0
votes
3answers
8k views

Import error :No module named MYSQLdb

I have a problem so a connection a python to database local of MySQLdb. Message of error is: import MYSQL ImportError:No module named MYSQLdb. This is a script in python 3.4 to connection my ...
0
votes
0answers
23 views

Access phpmyadmin

I hope u can help me :D So my Apache2 server and MySql are both running. PHP is also working. I already included this line in the apache Configuration : Include /etc/phpmyadmin/apache.conf I´m using ...
0
votes
1answer
21 views

Can you configure postfix in ubuntu to send a automated email when a user submits php webform?

How would you write a bash script to take a users informations from the php webform and email the user saved on the server using postfix when they submit the form? The users saved on the server should ...
1
vote
2answers
5k views

MySql won't start after installation on Ubuntu server 14.04.1

I'm new to Ubuntu server and MySql. I'm attempting to create a server in VirtualBox that I can use for web development and testing before deploying to a real server. I have Ubuntu server 14.04.1 ...