Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
18 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' ...
0
votes
0answers
12 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
0answers
14 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
22 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
36 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 ...
0
votes
0answers
13 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
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 ...
0
votes
1answer
19 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
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
3answers
221 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 ...
3
votes
2answers
56 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 ...
-3
votes
1answer
25 views

My sql password [on hold]

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 ...
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 ...
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 ...
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 ...
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 ...
1
vote
1answer
71 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 ...
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 ...
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
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
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
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
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
0answers
9 views

Lamp Server with two MySQL versions

I already have a LAMP Server running with MySQL version 5.5 and I want to add another MySQL version (5.6). Is that possible with Ubuntu 14.04.2 LTS? When yes, how can I do it?
1
vote
2answers
31 views

Unable to access remotely (LAMP issue)

I'm unable to access my home server remotely although it works fine in LAN. When I try to access it remotely using http://xxx.xxx.xxx.xxx/ I get router control panel page and when I browse ...
0
votes
1answer
31 views

Storing MySQL database in USB .. Permission problem (errno: 13)?

So, this page is what I'm using as a manual: Different locations for MySQL databases? I'm trying to store my database on USB (whether a good idea or not, please tell me how to do this if there is a ...
0
votes
0answers
25 views

Difficulty reinstalling MySQL on 14.04

I have recently upgraded to 14.04. After this upgrade I had various problems with apache, and my attempts to fix them appear to have wrecked my MySQL installation. I am attempting to reinstall MySQL ...
0
votes
0answers
12 views

How do I reset all MySQL databases, passwords, and settings, without resetting configuration?

As far as I know, MySQL comes with configuration to integrate with Apache and other Ubuntu software. To my knowledge, if I simply uninstall MySQL with Apt, that configuration will be lost. However, ...
0
votes
1answer
71 views

mysql-server apt-get install failing

I am trying to install mysql-server on a fresh copy of ubuntu/trusty64 (Ubuntu 14.04.3 LTS). I am using vagrant/virtualbox. I ssh into the box and run the commands below. You can easily replicate this ...
0
votes
0answers
26 views

Upgraded to 15.04. PHP/mysqli now having problems with “old passwords” Need to downgrade (what and how?)

I was using 14.04 and PHP 5.5. Upon upgrading, I can no longer use MySQL to access REMOTE and local databases because of old passwords: [Wed Jan 06 17:42:04.030738 2016] [:error] [pid 23736] PHP ...
0
votes
1answer
30 views

commands to upload database file to database

There is a database file in this path : /var/www/db.sql in server. Our database size is about 800mb. we have to upload this sql file to the database : "age" username : root, password : pass, ...
1
vote
0answers
28 views

I can not save data to MySQL when is tomcat running

I have tomcat 7 and mysql 5.5.46. On my tomcat is running simple application which reads data from mysql. I have another java program that stores data in to mysql. When running tomcat and java ...
0
votes
1answer
286 views

Unable to locate package libapache2-mod-auth-mysql

Trying to install this package on Ubuntu using sudo apt-get install libapache2-mod-auth-mysql, but I get the message in the title. Why and how can I fix it?
0
votes
0answers
115 views

Unable to start Mysql 5.7

I am having the following error: Not connected : Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) This is what is in the log files: /usr/bin/mysqladmin: connect ...
0
votes
0answers
9 views

mysql-client : Depends: mysql-community-client (= 5.7.10-1ubuntu12.04) but it is not installable [duplicate]

I have tried to upgrade my mysql in 12.04 from 5.5 to 5.7 but after removing 5.5 I had to add 5.7 to apt. However when I did apt-get install mysql-server it asked me to install 5.5 again. So I did the ...
0
votes
0answers
24 views

How to keep read value after break [duplicate]

Evening, I am trying to have the mysqlpass entry stay throughout the script, without the break getting rid of it. But I can't figure out how. while true; do read -p "Password for MySQL " ...
0
votes
0answers
23 views

Random disconnects Ubuntu 15

I don't really know where to begin. I have a desktop that I recently switched from Window 7 to Ubuntu 15.10. I use it as a server to host media to my Kodi clients throughout the house. It worked fine ...
1
vote
1answer
56 views

Trying to purge MySQL fails

I'm running in circles currently, trying to fix some mysql problem. I couldn't use apt-get for a while now, because it always stuck at the line Setting up mysql-server-5.6 (5.6.27-0ubuntu0.15.04.1) ...
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 ...
0
votes
0answers
25 views

MySQL service is not starting successfully after server reboot

I have an Ubuntu 14.04 server with plesk installed on. I have a problem with MySQL server, which seems I can't figure out the solution: Each time after the server reboot, MySQL service is not ...
1
vote
0answers
315 views

Plesk not starting after server reboot because of MySQL socket

I've a problem with my plesk (12.5.30) installation on a fresh Ubuntu14.04 LTS server. I used plesk autoinstaller file downloaded from plesk official website, to install plesk. It seems that the ...
0
votes
1answer
37 views

mysql dependencies installation problem

I am reinstalling mysql on a test server with Ubuntu 14.04 before I hadn't had any problems reinstalling it. When I reinstall it I do the following: use apt-get purge and remove on mysql-server-5.5 ...
0
votes
1answer
62 views

Why am I unable to connect to ftp, or git or mysql server from my ubuntu 14.04 LTS computer?

I am running on Ubuntu 14.04 LTS, and I used to manage my ftp connections through FileZilla, and use git through terminal as well as mysql through terminal... Then, today, nothing works. I try to ...
0
votes
1answer
25 views

“sudo start mysql” results in an error [duplicate]

minzaw@Dell-PC:~$ sudo start mysql [sudo] password for minzaw: start: *Unable to connect to Upstart: Failed to connect to socket /com/ubuntu/upstart: Connection refused* minzaw@Dell-PC:~$ sudo ...
0
votes
1answer
30 views

how can I create a MySQL account using terminal

I have tried using the root, but I receive errors. mysql -u root File "<ipython-input-6-c07024211ca7>", line 1 mysql -u root ^ SyntaxError: invalid syntax
0
votes
1answer
42 views

Ubuntu 14.04 LTS:error parsing `Gemfile`: Undefined local variable or method `urce' for Gemfile. Bundler cannot continue

I'm new to Web App Development beginning with Ruby On Rails. To get started I followed this. I'm in the final steps where it asks to create a Database (I'm using mysql) by running rake db:create but ...
0
votes
2answers
39 views

1045 Error using mysql -u root

i didn't find my answer on similiar questions so i ask my question here : I've followed the instructions on ApacheMySQLPHP page on help.ubuntu.com but after the installation of MySQL & using the ...
0
votes
1answer
52 views

Bulk email sending issue with Ubuntu 14.04 (Linode VPS)

I have an email server on Linode.com with the following specs: Ubuntu 14.04 Apache & MySQL Postfix, Dovecot, Spamassassin, Postgrey, RoundCube, sievemail components. Problem: Everything works ...