Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
3answers
4k 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
178 views

Can't login in phpmyadmin in ubuntu 14.04

I can't login in phpmyadmin using my root password. Moreover, it is not showing any error message too. When I enter password, it redirects to ...
0
votes
0answers
67 views

Cannot reset mysql root password

I can't login to the localhost phpmyadmin neither to the mysql server as root (through the terminal). On both places I get the #1045 error. I followed this answer but the queries were affecting no ...
0
votes
1answer
333 views

MySQL Server keep shutting down

mysql server is keep shutting down, i am using DigitalOcean 512 MB Memory and 20GB Disk. I am running WordPress and iRedMail. Here are my Error Logs: Version: '5.5.38-0ubuntu0.14.04.1' socket: ...
0
votes
1answer
77 views

Linux Ubuntu Mysql issue

I am not sure if something is wrong with my mysql (runing on dedi server). I might have missconfiguared something, or using a wrong port to connect to, or if it's getting blocked. I'm quite new with ...
0
votes
0answers
200 views

Installing Drupal 8 on a LAMP stack… 404 not found, alternate installation instructions?

I installed a LAMP stack, and followed instructions on how to install Drupal 8, but the page is 404 ing, there is either a problem with the steps, or how I followed them, and I am open to alternate ...
0
votes
1answer
78 views

Ok, I have problem with code for adding values into mysql db, there is a posts (db table, java form created in Eclipse)

package sokic; import java.awt.EventQueue; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.DriverManager; import ...
0
votes
1answer
713 views

Xampp MySQL and PhpMyamin error ubuntu 14.04

just installled latest xampp package on my localhost and on my terminal everything looks fine as shown below: **root@SKYBUNTU:/home/maze# /opt/lampp/lampp start Starting XAMPP for Linux 5.6.3-0... ...
0
votes
0answers
17 views

Query line working on widows does not work on mono

I migrated my program on Ubuntu 1.14.1 LTS Mono 1.7. MYSQL Localhost server version is 5.5.40 I have a method which works fine on Windows platform. I restore from backed up data in my hd format CSV ...
0
votes
0answers
23 views

where can I find mysql/ODBC library for gcc

I want to access a mysql database I have on my godaddy website from a C program. What GCC libraries should I download/install.
0
votes
0answers
71 views

ls command not showing latest file

I just did a mysqldump on my Ubuntu EC2 server. If I browse the directory in Filezilla, I can see the dump file, but not when I run the ls command in terminal. Why is this happening?
0
votes
0answers
17 views

Having difficulties in installing mysql 5.6 on ubuntu 14.04 [duplicate]

I am new to Ubuntu. I have been able to install Ubuntu on Windows 7 using VBox virtual machine. I am facing difficulties regarding setting up of Mysql5.6 on my Ubuntu box. It gives me various ...
0
votes
0answers
115 views

VirtualBox shared folder Apache and MySQL access

I've got some problems with Ubuntu 14.04 Desktop Guest on Virtualbox. I have shared folder from Win 8.1, in which I keep my www and mysql files. mysql and www-data users are added to vboxsf group: ...
0
votes
1answer
208 views

How do I fix amavis mysql warning “execute failed: Unknown column 'rseqnum'”

If you are using amavisd-new with a SQL server (Docs are located in /usr/share/doc/amavisd-new) you will see error messages similar to this: (!)WARN save_info_final: sql exec: err=1054, 42S22, ...
0
votes
1answer
92 views

Trying to setup a mail server on ubuntu 14.04

I'm trying to set up a mail server but get the following errors whilst trying to connect with thunderbird: Jan 7 03:11:59 Ubuntu-1404-trusty-64-minimal postfix/smtpd[6752]: lost connection after ...
0
votes
0answers
347 views

Error in Processing Request Error code: 403 Error text: Forbidden

I have read the answer in Why do I always get a 403 error with phpMyAdmin? but it doesn't resolve my issue can anyone suggest me the quick solution. I am using ubuntu server version 14.04 My ...
0
votes
0answers
22 views

mysql in lamp-server doesn't work [duplicate]

Just got myself a new VPS hosted at VPSDime and cannot get mysql to work (mention the host since I've never had the error before). I've had 2 fresh installs of both Ubuntu 14.04 LTS and 12.04 LTS and ...
0
votes
0answers
56 views

MySQL leaves empty logs?

I've been using MySQL to hold a database catalog of my music for another service I'm running on the server. I believe I set it up correctly, however, my logs /var/log directory gets filled with empty ...
0
votes
1answer
70 views

MySQL messed up apt-get? [duplicate]

I tried to install MySQL for my localhost and I managed to break my dependencies, and I can NOT install anything I have tried: Purging MySQL commons, client, server, ect. Removing MySQL commons, ...
0
votes
1answer
123 views

Unable to reinstall MySQL

What I did before this error: I was trying to install mysql for registration in OpenMRS database and it was succesfully, but i forgot my password. And removed mysql packages, i was getting some errors ...
0
votes
0answers
25 views

mysql-server not installing on ubuntu [duplicate]

I had a problem in mysql login so i tried to reinstall mysql-server But I am unable to reinstall *Ubuntu Version 13.04 I tried following command apt-get update apt-get install mysql-server ...
0
votes
1answer
97 views

Install second mysql

I have a VM that has mysql 5.5.40 installed in it. And now i want to install mysql 5.6 without updating or replacing existing version. Means i want to use these two side by side. I have tried to ...
0
votes
1answer
15 views

MySQL Not Found and Other Problems

I'm on Lubuntu. I've installed lamp. PHP works, so does myphpadmin. However, when I try to run MySQL, there is a 'not found' error. How do I solve this? Also, I mistakenly symbolically linked mysql ...
0
votes
0answers
65 views

PHPMYADMIN /phpmyadmin was not found on this server

PHPMYADMIN is installed in my computer and I removed and reinstalled it just now Yet I am unable to access the phpmyadmin Your suggestions are kindly appreciated. Thank you in advance
0
votes
1answer
382 views

MySql - can i make a new connection in windows calling a linux ip address

So trying to figure out if i can use workbench in windows 2008 server and ask it to connect to a linux machine over my network. the reason behind this is my frontend application is in windows however ...
0
votes
0answers
357 views

Cannot install (configure) mysql on Ubuntu 14 server using apt-get

When installing mysql-server-5.5 on Ubuntu 14, I get the latest mysql-server with: sudo apt-get install mysql-server Which asks to install mysql-*-5.5 packages. I am then prompted to give a ...
0
votes
0answers
684 views

Cannot create a new connection in MySql Workbench

Cannot create a new connection using workbench using ubuntu The message is "Failed to Connect to MySQL at 127.0.0.1:3306 with user root" Can somebody please help me.
0
votes
0answers
38 views

problems while creating procedure in sql

whenever i create procedure in sql it always gives me the result as "procedure created with compilation errors" I am using oracle 10g.I don't know what should I do overcome this.
0
votes
2answers
155 views

Permission denied when trying to upload to /var/www

I made a Website which i want to publish right now. I asked someone if he could host it and later i got an e-Mail telling me it is all set up. Including a Admin Name and Password and also a MySQL root ...
0
votes
0answers
88 views

Backup database with mysqldump

Hello i use mysqldump with crontab for save my database each hour but after one day i have 24 files What is solution for auto delete if more 5 files ? And what is chmod for folder backup for security ...
0
votes
1answer
38 views

MySQL starts run manually with datadir param, but doesn't as a service

Why does sudo service mysql start not start? But a manual likes sudo mysqld --datadir=/newlocation does? I have moved the data to new external harddrive formated as ext4. I updated my.cnf with the ...
0
votes
0answers
69 views

Load Balance Nginx, SSL, MySQL

So I need to load balance Nginx servers, can someone give me a good tutorial or explanation. With SSL is there such thing as load balancing SSL? I've heard of it. And clustering MySQL, how can I do ...
0
votes
2answers
167 views

Can I use iptables to forward vm guest requests to host

This is a bit complicated, but I have a Windows 7 vm (virtualbox) and I need create a persistent connection to the MySQL instance on my host machine. Binding... I can do this using mysql address ...
0
votes
0answers
16 views

MySql error in Edubuntu 12.04

As this the first time I m here to ask, as unable to run mysql on edubuntu 12.04 with following error. Kindly help in tracing the error.... thanks gnps@gnps-ibm:~$ mysql -u root -p Enter password: ...
0
votes
1answer
167 views

while installing phpmyadmin getting dependency in ubuntu 12.04

i am newbie in ubuntu/linux system. i am trying to install phpmyadmin and i am getting following error. Some packages could not be installed. This may mean that you have requested an impossible ...
0
votes
2answers
29 views

Where is my downloaded software

I have just downloaded and installed MySQL Server from download centre. It says it is installed but where is it? I have looked in all the usual places any help appreciated
0
votes
1answer
52 views

Ubuntu Server 14.04 web server not gathering data from mysql server

First of all: I am a beginner, and have only basic knowledge about linux and servers. Also, this question is kind of vague, but i hope you can help. I would be very thankful for all kinds of feedback ...
0
votes
1answer
144 views

Mysql installation in Ubuntu [duplicate]

I had seen many answers to install MySQL. I had tried everything. It shows: There's no MySQL already installed Unable to locate package MySQL-server For synaptic, there's no keyword found Unable to ...
0
votes
1answer
29 views

Package list file lists the wrong version of MySQL [closed]

ubuntu-14.04.1-server-amd64.list in http://mirror.internode.on.net/pub/ubuntu/releases/14.04.1/ lists version 5.5.38 of MySQL server ...
0
votes
0answers
76 views

Ubuntu php5-fpm www.conf pooling

Ubuntu VPS with 4GB RAM running wordpress with nginx, php5-fpm, and percona mysql 5.5 Daily unique visitors 8000 Maximum concurrent connections 90 For the above which is better www.conf (php5-fpm ...
0
votes
1answer
748 views

trouble in installing mysql workbench

i am trying to install mysqlworkbench in my ubuntu using sudo dpkg -i mysql-workbench-community-6.0.9-1ubu1310-amd64.deb.3 but getting following errors (Reading database ... 188276 files and ...
0
votes
0answers
24 views

Problem with i7 notebook running ubuntu - Good hardware

I use ubuntu 14:04 on a notebook for web development. However, about 3 times a day it enters 'bottleneck'. The processing and memory usage go into space. Patiently when I'll see what is happening with ...
0
votes
2answers
306 views

How to install MySQL in Ubuntu Minimal 12.04

How can I install MySQL in Ubuntu Minimal 12.04? When I try to apt-get install mysql-server (as root) even after apt-get update and apt-get upgrade in a fresh install, I receive this: # Setting up ...
0
votes
0answers
144 views

Ubuntu Minimal 12.04 with MySQL installation errors (and minor issues, like the lack of Dialog and ReadLine)

I am trying to start my server with Ubuntu Minimal, because I will not use 90% of the default stack included in Ubuntu Server. But I can't install MySQL, getting erros like these: # Setting up ...
0
votes
0answers
159 views

copy the MySQL Connector/J jar file to the domain-dir/lib directory

Where is the MySQL JDBC connector JAR supposed to go? To do this, copy the MySQL Connector/J jar file to the domain-dir/lib directory. For example, copy mysql-connector-java-5.1.30-bin.jar to ...
0
votes
1answer
225 views

/usr/lib/i386-linux-gnu/libmysqlclient.so.18: no version information available

I wrote a program in C++ (QtCreator) on Ubuntu 14.04 LTS which reads values from Web-API's (curl) and stores them in a MySQL Database (using the MySQL C-API). When I start the program on my Desktiop ...
0
votes
0answers
174 views

Scheduled Cron Back up from EC2 to S3

I have created a script for scheduling sql back ups and store in Amazon S3. Below is the script that I used for taking backups. DATABASES="testdb" testdb_USER=root testdb_PW=root ...
0
votes
2answers
777 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
0answers
190 views

Mysql connection error

I'm newly installed Ubuntu 14.04 on my system. And I individually installed apache2, mysql 5.6.19 and PHP Version 5.5.9-1.whenever I connect to database it's giving error in the console window like ...
0
votes
0answers
55 views

access denied from local host

Ok, I've set up my server and have been having fun designing my website. At the moment I've got several php files that access my MySQL databases. everything is ok client side and the php has no ...