Questions tagged [mysql]

Questions regarding the MySQL database server, client and tools.

1,088 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1 vote
0 answers
638 views

Convert SQL Server Stored Procedure into MY SQL Stored Procedure

Any tools are available to Convert SQL Server Stored Procedure into MY SQL Stored Procedure. We tried with some license tool but only tables are created properly, but Stored Procedure are created ...
PrabhuR's user avatar
  • 11
1 vote
1 answer
977 views

After updating MySQL password in safe mode, I still cannot login to phpmyadmin

Server info I'm running an Ubuntu 14.04 server with apache and some other goodies installed. Problem I previously had a plesk trial installed but it expired so I uninstalled it. Ever since then mysql ...
Ryan Cady's user avatar
  • 111
1 vote
0 answers
231 views

Can't find job mysql on crouton precise

I'm using Ubuntu precise as chroot in my chromebook machine. I'm trying to install mysql through apt-get install mysql-server. The thing is, when I try to start it, it can't find the job: (precise)...
user1550608's user avatar
1 vote
0 answers
492 views

ProFTPD - set a group manager to access all users files in the group tree

I am currently developing a client application with pyqt and ftplib to help backup/restore file to/from a ProFTPD server. The company is divided into many agencies and every agency is a ftp group with ...
BoCyrill's user avatar
  • 111
1 vote
0 answers
2k views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' in Ubuntu 12.04.5 LTS

I encountered with the error Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' in Ubuntu 12.04.5 LTS. So,I uninstalled mysql 5.5 from Ubuntu 12.04.5 LTS.But when i tried ...
titto.sebastian's user avatar
1 vote
1 answer
487 views

Problem with libmyodbc - segfault error

I have an issue with libmyodbc as I am not able to connect to the MySQL database that it is pointing to. When I try from isql I get a "Floating point exception (core dumped)" error, and when I try ...
Dennis A.'s user avatar
1 vote
0 answers
35 views

Upgrading to 15.04 stalls when trying to install MySQL 5.6

I've just tried to upgrade my ubuntu OS (desktop) and it's just stopped when installing MySQL. It said that i had to update the password (did this twice in the install) but the second time it said "...
Andy's user avatar
  • 111
1 vote
0 answers
241 views

MySQL wont start on boot after upgrading to 15.04

I recently rebuilt my server and decided to upgrade from 14.04 LTS to 15.04. I can't seem to figure out why MySQl won't start on boot. I have ran the following command. sudo update-rc.d mysql ...
Vinh Nguyen's user avatar
1 vote
0 answers
892 views

Have localhost with dual boot (Windows/Ubuntu) share htdocs & mysql databases with XAMPP

I just got a new machine with dual boot Ubuntu+Windows 8.1 and set up a localhost using XAMPP in a way that allows me to edit and preview the files on both OSes (so htdocs and mysql databases have to ...
MauroB's user avatar
  • 11
1 vote
0 answers
2k views

Difference between using mysql in xampp and using mysql separately

I have used xampp on windows to do some php programming(basic) and now i'm trying to do some python/perl database connectivity programs(again basic) with mysql. The thing is when i used xampp, it ...
suresh kumar's user avatar
1 vote
1 answer
7k views

I Get 'Import error : No module named MYSQLdb' in python 2.7. I've tried everything from the other similar thread

The error: import MySQLdb ImportError: No module named MySQLdb. Particulars: OS is Ubuntu 14.04 python 2.7.10 and is the default MySQL 5.5.43 What I've tired: sudo apt-get install build-...
Grawlix's user avatar
  • 11
1 vote
1 answer
2k views

Where is .sql file located on Lamp Server using Ubuntu 14.04?

I need to import my .sql file from my MySQL database as an attachment and cannot find where it is located. I am using Ubuntu 14.04 LAMP with Apache 2.4.7. Can anyone help?
SevenWest's user avatar
1 vote
0 answers
239 views

Unable to get MySQL Utilities (mysqlrpladmin) to work properly under Ubuntu 14.04

I currently have replication running between 1 master and 2 slave servers. When I attempt to run mysqlrpladmin using the "--discover-slaves-login" option and "health" command, it only returns the ...
play2win's user avatar
1 vote
0 answers
502 views

Can`t reinstall mysql on kubuntu

Every time I try to install MySQL I get Setup package mysql-client-5.5 (5.5.41-0ubuntu0.14.04.1) … Setup package mysql-server-5.5 (5.5.41-0ubuntu0.14.04.1) … 150415 15:35:15 [ERROR] Can't find ...
Crusader's user avatar
  • 210
1 vote
0 answers
2k views

On connecting to MySQL via SSL getting ERROR 2026 (HY000): SSL connection error: protocol version mismatch

I am working with MySQL and generated the certificates to use with MySQL to enable SSL. Here are SSL configs: mysql> show variables like '%ssl%'; +---------------+----------------------------+ | ...
Shivam Bajpai's user avatar
1 vote
0 answers
934 views

ISPCONFIG Ubuntu 14.04 phpmyadmin 404 Not Found

After following this tutorial https://www.howtoforge.com/perfect-server-ubuntu-14.04-apache2-php-mysql-pureftpd-bind-dovecot-ispconfig-3-p4, and successfully completed when i try to acces phpmyadmin ...
Bogdan Crișu's user avatar
1 vote
0 answers
62 views

Something wrong with my terminal

I am trying to run this command apt-get install mysql-server and it sets up the packages but when it reaches a point where a password input is needed, this is the screen i am getting I can't even ...
jsjsjsjsjsjs's user avatar
1 vote
0 answers
731 views

Why are MariaDB versions different with same configurations?

So, last night I install a fresh copy of ubuntu 14.04 and followed some instructions for installing MariaDB as follows: > sudo apt-get install software-properties-common > sudo apt-key adv --...
Amadeus's user avatar
  • 111
1 vote
1 answer
4k views

XAMPP MySQL and phpMyAdmin error Ubuntu 14.04

Just installed 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... XAMPP:...
moise andre's user avatar
1 vote
2 answers
1k 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 ...
bfuzze's user avatar
  • 129
1 vote
0 answers
1k views

Problem connecting to database via SSH with MySQL Workbench

I am having trouble connecting to an external database via SSH with Workbench. The error that I get says: Could not acquire management access for administration UnboundLocalError: local variable '...
Diego-MX's user avatar
  • 608
1 vote
0 answers
550 views

dependency issue while installing phpmyadmin on nginx webserver

I tried to find a solution for this problem for a long time but I cannot find it. Maybe you can help me. I have Ubuntu 14.04 installed on my system and want to use it for web development using nginx. ...
DeHollaender's user avatar
1 vote
0 answers
1k views

Server slow after Nginx errors and restarting PHP

I have a server with Intel Xeon 2xE5520 2.27GHz, 48 GB Ram, 2x146 GB 15K HDD (Raid) OS Ubuntu 14.04.01, Nginx 1.6.2, PHP 5.5.9, MySQL. Webmin. My website is video portal. Traffic is approximately ...
David Namchevadze's user avatar
1 vote
1 answer
2k views

Cron job from mysql and send an email with results

I have a ubuntu box hosted and need to setup a cron job for executing a stored procedure and sending the results via email to one address once a week. How can I do this? I am using Mailgun
tjhack's user avatar
  • 123
1 vote
1 answer
1k views

libmysqlclient error. No file (even though its there)

Trying to launch a program. I get the error as follows: ./theforgottenserver: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory I ...
Zac's user avatar
  • 11
1 vote
1 answer
2k views

XAMPP (LAMPP) on Ubuntu Touch

Can I install and run XAMPP (LAMPP) on Ubuntu Touch on a Nexus 10 in order to host a local website (that needs PHP and MySQL)?
user298623's user avatar
1 vote
0 answers
208 views

Apache and MySQL bringing server to a crawl several times a day

I am having difficulty troubleshooting a bottleneck problem with my Ubuntu 12.04 server. I run a very small intranet website off of the server. There are web requests (SOAP, HTML, REST, etc) at a ...
mminnie's user avatar
  • 11
1 vote
0 answers
6k views

Apache Timeout (Problem loading page) on localhost

I am running a php script locally in my Firefox web browser. After exactly 300 seconds I get an error page. "Problem loading page. The connection has timed out. The server at localhost is taking too ...
Daigu's user avatar
  • 11
1 vote
1 answer
629 views

Postfix / Dovecot / MySQL- doesn't work!

I have just installed a Mail- Server on Postfix and Dovecot using MySQL to authenticate the user. But if I try to conntect to the Server via Outlook or Thunderbird, the following Error appears in the ...
user287331's user avatar
1 vote
1 answer
577 views

Postfix and Ownclound mysql authentication

i'm using ubuntu 12.04 with roundcube/postfix and owncloud installed, and using mysql as login authentication. i would like to know if it's possible to make single login for these apps (without LDAP) ...
user283856's user avatar
1 vote
1 answer
2k views

Copying Folder while Preserving Permissions/Ownership Error: operation not permitted

I am trying to copy a folder while preserving ownership. When I use the command: sudo cp -R -p /var/lib/mysql /newpath the files copy but the ownership changes (my username becomes the owner on the ...
Michael's user avatar
  • 195
1 vote
0 answers
217 views

Error Changing MYSQL Data Directory

I was trying to change the mysql data directory following these instructions. When I try to restart the database with step 8: sudo /etc/init.d/mysql restart Gets the following errror: Rather than ...
Michael's user avatar
  • 195
1 vote
1 answer
3k views

Install MySQL in Ubuntu for XAMPP in 14.04

I was having problem since some time using XAMPP. In terminal the MySQL starts as normal but when it comes to app, it saying MySQL stopped working. So I removed MySQL and hope installing it again will ...
user227495's user avatar
  • 4,069
1 vote
0 answers
520 views

Ubuntu 12.04 problems with mysql

I use Ubuntu Server 12.04 for my Django project. On my local PC there is no errors and etc. Sometimes on server I have error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/...
Leon's user avatar
  • 429
1 vote
3 answers
6k views

Apache unable to connect to MySQL

I installed apache server (this story). I cannot connect with remote (I tried local too) mysql server. After a long loading page I get error MySQL database connect failure. Mysql server is far from me....
serezha93's user avatar
1 vote
3 answers
6k views

Can't connect to local MySQL server through socket '/tmp/mysql_2.sock' during manual installation of mysql

I get the error below when attempting to manually install mysql-5.6.17-linux-glibc2.5-x86_64 Steps I followed: 1. tar -xzvf mysql-standard-5.1.34-linux-i686-glibc23.tar.gz 2. ln -s mysql-...
BioDeveloper's user avatar
1 vote
0 answers
1k views

Subdirectories Show 404 Not Found on 13.10 web server

I recently set up a web server on Ubuntu 13.10 and when I enter the external IP it works fine showing the index file of var/www/ but whenever I try to add a folder, say one called test, and I go to ...
derekshull's user avatar
1 vote
0 answers
609 views

What does this mysql error mean?

I'm on Xubuntu 13.10 64 bit. I know the password of my mysql database, but still can't login as root. I try to change the password sudo mysqld_safe --skip-grant-tables & I get [1] 8863 mypc ~: ...
Lynob's user avatar
  • 6,665
1 vote
1 answer
553 views

MySQL script does not stop, reboots mysql

I have installed ubuntu 13.10 desktop x64 on my laptop. After the installation I installed MySQL Server sudo apt-get install mysql-server mysql-client Installation wass successful but I noticed the ...
Christopher Ebejer's user avatar
1 vote
1 answer
2k views

"Error loading MySQLdb module" when installing custom app

I am installing a custom app that needs MySQL, which I already had working so I am a bit confused on what's going on. Anyways here is the error: Error loading MySQLdb module: this is MySQLdb version ...
Guardian's user avatar
  • 113
1 vote
0 answers
735 views

Update and Upgrade updated mysql and now "Job failed to start"

I ran apt-get update and apt-get upgrade earlier today and I had a conflict with the my.cnf file I saw default=n so I pressed "n" and went on my merry way. I now can't start mysql via service mysql ...
ThomasReggi's user avatar
1 vote
1 answer
802 views

How to change phpmyadmin username from root to something else?

I can't seem to find a resource in the internet that explains how to do this from the command line or phpmyadmin. I'm using Ubuntu Server 13.04 in Amazon EC2.
anlogg's user avatar
  • 291
1 vote
0 answers
428 views

Problem after installing phpmyadmin

I installed apache, mysql, and php on my Ubuntu 12.04 server but after logging in all I see is a white screen displaying a forward slash. Is there something else I need to configure or enable? / ...
CR47's user avatar
  • 141
1 vote
1 answer
303 views

package installation error

I was trying to install mysql server 5.6 via deb file and the software installer froze and force quited. After that when i tried to install mysql via the command sudo apt-get install mysql-server ...
Hunoku's user avatar
  • 25
1 vote
0 answers
408 views

How to set up a DNS server on ubuntu server?

This DNS server will use to access a web server/ mysql server. Scenario: DNS Server of 192.168.0.0/24 network - 192.168.0.2 domain name(dn): my.site.com redirect to 192.168.2.1 (webserver/mysqlserver) ...
ckknight's user avatar
  • 303
1 vote
0 answers
159 views

Mount Drive at Start-up but MySQL can't see it

I'm trying to automount my drive using the following command in startup applications: /usr/bin/udisks --mount /dev/sdd1 However, MySQL fails to start when I mount the disk. On the contrary, if I ...
Jester87's user avatar
  • 133
1 vote
2 answers
231 views

Have I over-installed MySQL?

I ran the following from the terminal: sudo apt-get install mysql-server mysql-client I then checked to see if MySQL was running: sudo netstat -tap | grep mysql I saw something similar to this:...
David's user avatar
  • 463
1 vote
1 answer
782 views

how to install apache/php from apt alongside mysql 5.6 from source

I managed to install MySQL 5.6 on obuntu 12.10 but now I need apache/php packages but when I try to install them thorough apt they try to install mysql-common (presumably 5.5) How to solve this?
greg606's user avatar
  • 121
1 vote
2 answers
631 views

Database create in mysql database

I am using Ubuntu 12.10 and recently I install XAMPP 1.8.1. My problem I can not create new database using both sql command and phpmyadmin. In phpmyadmin database creation input box is not shown and ...
sonnet's user avatar
  • 13
1 vote
2 answers
208 views

Installing MySQL in LAMP

I managed to install Apache and PHP on my Ubuntu Installation, however when I try to install MySQL using this command sudo apt-get install mysql-server It mentions that there are broken packages. ...
Yoosuf's user avatar
  • 11

1
6 7
8
9 10
22