Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
15 views

apt-get substitute MariaDB in place of MySQL

I am trying to install postfixadmin on Ubuntu. I have MariaDB installed and want to use that as my MySQL database. However, the package dependencies for postfixadmin are MySQL, not MariaDB. Is ...
0
votes
0answers
17 views

Phpmyprepaid “setup.php” displays messy code

Help me ! I want to install "phpmyprepaid" on Ubuntu 14.04, on the tutorial they say to open this link on my browser. http://my-ip-address/phpmyprepaid/www/install/setup.php but it show this result ...
-1
votes
1answer
10 views

problem during GSN installation

grant usage on . to gsn@localhost identified by ‘gsnpassword’; is this a correct syntax for user 'gsn' to connect to the server from localhost using the password 'gsnpassword':in Mysql Server version ...
0
votes
1answer
31 views

Mysql installation failed

Mysql server is failed to start suddenly, so I just uninstalled it and tried to reinstall again. But, While installing the mysql server using #apt-get install mysql-server-5.6 I got the following ...
0
votes
0answers
18 views

updating Ubuntu, version differences

Okay, so after looking through the forum and carefully checking the 'may already have your answer' section. I have decided to ask this question. First some background, I'm in charge of about 9 Linux ...
0
votes
0answers
4 views

Apache2 - Virtual host stops my MySQL server

I have really strange problem. I have an Apache2 server on Ubuntu 14.04 with installed MySQL server. Everything was working fine. I have multiple domains hosted on one server and i believe i received ...
0
votes
0answers
36 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 ...
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
20 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
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
36 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
41 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
1answer
22 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
26 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
24 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
274 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 ...
2
votes
2answers
61 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 [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 ...
0
votes
0answers
26 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
74 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
81 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
24 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
19 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
12 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
26 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
17 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
10 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
32 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
34 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
28 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
72 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
29 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
29 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
340 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
131 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
25 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
58 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
23 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
27 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
423 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 ...