Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
15 views

errors on cam survey

I am getting the following error: Failed to load resource: net::ERR_FAILED chrome-extension://fmfcbgogabcbclcofgocippekhfcmgfj/cast_sender.js Failed to load resource: net::ERR_FAILED chrome-extension:...
0
votes
1answer
87 views

Problem with Java and JavaScript

So tomorrow I'll be doing some labs for MySQL certification, and since in my country I can't get class training I had to choose Training On Demand (TOD) which is a good way to learn (You have recorded ...
0
votes
0answers
146 views

How to automate MySQL-Server without prompts in bash?

I would like to know how to automate the MySQL-Server installation through bash script on a Ubuntu 14.04 x64 LTS server using apt. I use a server on digitalocean and tried many solutions but none of ...
0
votes
0answers
88 views

Unhandled exception can't connect to mysql server on '127.0.0.1' (111) (code 2003)

I am new to Ubuntu using version 14.04 64-bit. I have successfully installed xampp and all services are running correctly. However I have installed mysql workbench and then I get the error; Unhandled ...
0
votes
0answers
31 views

Configuring Ubuntu for hosting Podcast

I want to be able to host podcasts. I have been trying to set up a MySQL server and even ordered some books but I'm not sure if it's the right system for what I want. I have no problem with audio ...
0
votes
1answer
36 views

I just installed xampp on ubuntu 14.04, mysql is not starting in control panel

I just installed xampp on ubuntu. When I am starting xampp using sudo /opt/lampp/xampp start, I am getting: XAMPP: Starting Apache...already running. XAMPP: Starting MySQL...ok. XAMPP: Starting ...
0
votes
0answers
91 views

copy table from one database server to another server in mysql

I am working on cronjob to transfer data from one server to another and after transfer is completed the first server database table should be empty for that I am using following commands but that ...
0
votes
0answers
21 views

Installation of MySQL community server offline

I've tried installing MySQL community server offline but it gives me this error E: unable to locate this package. What commands can I run to successfully install MySQL offline?
0
votes
0answers
27 views

Mysql 5.6 and 5.5 error while installing in ubuntu 14.04?

Following error i got during mysql installation: start: Job failed to start invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing package mysql-server-5.6 (--configure): ...
0
votes
1answer
3k views

MySQL 5.7 No directory, logging in with HOME=/

I'm sorry if this question has already been asked, but I can't find any solution to this (maybe small) issue: I just made a fresh install of mysql-server 5.7 on a 14.04 server. Every time the MySQL ...
0
votes
1answer
28 views

web interface tool for mysql administration

I want simple web interface tool for client to insert in MySQL table. I use phpmyadmin but I need another tool being more simple
1
vote
1answer
46 views

Mysql ERROR 2002 (HY000)

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) i am unable to understand, how to resolve this ?
0
votes
0answers
27 views

File Rights messed up! :(

For homework I need to manually make an LAMP server (i am a beginner) I did the installation and configuration of Apache, Mysql and php with my "root" user and then after that i came beware of errors ...
0
votes
1answer
66 views

How to solve the problem “package is broken or not fully installed”?

I am new in using Linux and I just installed a package name openimscore-fhoss and then during the installation they asked me to put the password for the SQL database but I made a mistake when enter ...
0
votes
0answers
41 views

service mysql status shows wrong status

I am recently facing a weird problem with my freshly installed Ubuntu 14.04.4 LTS. I am running apache and mysql on my server and I would like to start both on startup. Do to so, I added them to rc.d ...
3
votes
1answer
42 views

Why Perl is included into lamp-server^?

I know there are many methods and many questions about LAMP installation. However, non have an answer for... Why does command sudo apt-get install lamp-server^ installs some Perl libraries? As ...
0
votes
0answers
141 views

PHP doesn't use upgraded MySQL 5.7 on 14.04

I successfully upgraded MySQL to version 5.7 using this tutorial: http://www.devopsservice.com/installation-of-mysql-server-5-7-on-ubuntu-14-04/ However, when I look at phpinfo(), my PHP is still ...
0
votes
0answers
143 views

Can't view any php files stored in var/www/html

Im new to Linux and the whole idea of apache. I created a website using php, html and css. I used wampserver, phpmyadmin and mysql. All worked fine on my laptop. Recently I thought of a project to ...
0
votes
1answer
130 views

How to completely delete MySQL for clean install

I need to completely delete everything about MySQL. It was not starting so I decided to delete it. However during installation this happened: sta@daPC:~$ sudo apt-get install mysql-server Reading ...
1
vote
1answer
100 views

Database Data transfer from one server to another server in linux

Hi this is Ravindra and i have one question that i want to copy table data from one database server to another pc database server periodically after 7 or 10 days automatically in linux through cron ...
0
votes
0answers
54 views

slow queries on mysql server

I have a lamp server based on UBUNTU. My issue is that if I run the query (not all of them but just two) directly on the server itself they take no more than 5 seconds each. If on the other side I ...
1
vote
1answer
80 views

sh script works manually but not via cron

I have a cronjob created using this tutorial: http://www.matt-helps.com/automatic-backup-of-mysql-database-to-s3/ It works when i run this command sudo sh s3BucketBackupScript.sh But I can't get it ...
0
votes
2answers
220 views

`mysql-server` won't install

I've been trying to install mysql-server for 2 hours. The system is on Ubuntu Wily. There's nothing added in the log files. root@Erman:~# dpkg --configure mysql-server-5.6 Setting up mysql-server-5....
0
votes
0answers
95 views

Mariadb Plugin 'unix socket' is not loaded

After installing Mariadb on Ubuntu 15.10 I was unable to use mysql. The following error was reported: Plugin 'unix socket' is not loaded. It seems that plugin table in the mysql db was empty. Why ...
0
votes
1answer
130 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
48 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
12 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
97 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
22 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
10 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
248 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
59 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
56 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
241 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
147 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
111 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 = /usr/lib/i386-linux-...
0
votes
0answers
30 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
135 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 ‘/etc/php5/mods-...
0
votes
0answers
32 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
29 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
960 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
78 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
29 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
69 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
28 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
43 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 mysql-...
1
vote
0answers
121 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 http://stackoverflow.com/questions/...
1
vote
1answer
193 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
23 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
96 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: ...