Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
611 views

initctl: Unknown job: mysql ubuntu 12.04.4

I just updated my Ubuntu and mysql service wont start up. I've tried to re-install million time, i still get this error message: initctl: Unknown job: mysql The error log shows this: ERROR: 1064 ...
1
vote
2answers
83 views

How do I check services requiring a restart (of services, not the machine) by installing updates to other packages

If I run sudo apt-get upgrade then I get shown a list of packages and if any of these are services, they may need to be restarted (which is done automatically when installing the updates). How can I ...
0
votes
1answer
96 views

MySQL Ambiguous Option issue

MySQL is starting correctly as a service, and my WP instance / phpMyAdmin connects to it successfully. However, I've managed to screw something up such that when I try to log in from the prompt, ...
0
votes
1answer
452 views

Ubuntu Server 14 MySql php connect problem

I have ubuntu server 14.04 installed along side Apache, PHP5 and MySQL server all together. I can gain access to the server using putty and the mysql database using Heidi Sql remotely. On my laptop, ...
0
votes
1answer
37 views

After installing mysql-server, and doing $mysql, mysql won't start. Mysqld.sock missing

First, I installed mysql-server Next, I did $mysql I was going to add a database and edit some stuff. But I got this error: ERROR 2002 (HYOOO) : Can't connect to local MySQL server ...
0
votes
1answer
76 views

Starting mysql server problems

I am trying to get mysql (server?) to start. This is what I keep on getting: Rather than invoking init scripts through /etc/init.d, use service(8) utility, e.g. service mysql start THEN when I do ...
0
votes
0answers
68 views

Where do I put database and sub-database files in MYSQL? My mysqld.sock is missing, and some phpmyadmin login problems

I used to run WAMP in my old computer. I have gotten into linux and I wanted to take my website from my old computer and put it here and run it with APACHE2, MYSQL, and PHPMYADMIN. I have decided not ...
0
votes
0answers
70 views

phpmyadmin will not let me log in, and mysqld.sock is missing

I have quite a few errors when trying to make a website with LAMP. Error #1: mysql: (I have no idea what's causing it.) mysqld.sock is missing. When I type in $mysql it will say it can't connect ...
1
vote
5answers
7k views

MySQL error: The partition with /var/lib/mysql is too full!

I get this error when trying to start MySQL: The partition with /var/lib/mysql is too full! Here is the output of df -h: Filesystem Size Used Avail Use% Mounted on /dev/sda1 455G 77G ...
0
votes
0answers
21 views

404 when accessing phpmysql

I need some hand holding. I have a website on AWS. It was setup by someone else, so was not involved with the setup process. I have access to the site via winSCP. I know that it is Ubuntu but not ...
0
votes
1answer
1k views

Cannot Install/Start MySQL Server

Okay, I decided to migrate from MySQL Server 5.5.37 to Percona Server 5.6. I ended up removing MySQL Server by the following: sudo apt-get --purge remove mysql-server mysql-server-5.5 ...
1
vote
2answers
52 views

MySQL takes ages to load (only when using WP)

I'm not sure what's happening but it's since a while that I'm experiencing using my dev site (running on a VM) on the local Ubuntu machine. The site runs on a Wordpress instance using MySQL setup to ...
0
votes
3answers
93 views

mysql questions for beginners

ok, I have a few questions regarding mysql. I am currently running ubuntu 12.04.4 LTS command line version. I am looking for a database that I can use. I am confused at this point because I am ...
0
votes
0answers
65 views

Emma - MySQL Server has gone away

I'm using Emma to connect to remote MySQL server. After about minute inactivity I have to reconnect to server to execute query, which is very cumbersome. It looks like this problem appears only when ...
0
votes
0answers
460 views

Problem after installing phpmyadmin in ubuntu 12.04

I have installed phpmyadmin from the following process sudo apt-get install phpmyadmin Then I opened it throghhttp://localhost/phpmyadmin/ But after giving username and password then pressing the ...
1
vote
1answer
221 views

MySQL SSH Connection Setup

I want to connect to a MySQL db (running Ubuntu 14.04) with my Mac (running Mavericks). I will be connecting remote- home to work. How do I setup the ssh connection on MySQL workbench? Also, where do ...
1
vote
0answers
1k 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 ...
0
votes
0answers
24 views

Test dev website

The task is to drop a few MySQL tables from a dev site and test if that generated any errors on the site, before doing it on the live site. Since the site is also a live site, I included the dev site ...
1
vote
1answer
201 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 ...
0
votes
1answer
474 views

Unable to connect to mail server via IMAP and roundcube

I am having trouble getting the final parts of my mail server up and working. I followed this tutorial to get everything set up on the mail server side. I have installed roundcube for webmail and ...
0
votes
1answer
209 views

php5, mysql, phpmyadmin not working in ubuntu14.04

I have already installed lampserver in ubuntu 14.04. when i try to run http://'127.0.0.1', it shows it works. but it does not work when i try to run http://'127.0.0.1'/test.php. I have already created ...
0
votes
1answer
387 views

Auth succeeded No requires line available

Upgrading to Ubuntu 14.04 (and Apache2 2.4) server I can't use MySQL as htaccess; Before upgrading I was using MySQL as htaccess in the virtual host - worked nicely: <Directory ...
0
votes
1answer
136 views

MySQL not working after server reboot?

Because of problem with host company node I migrate from one node to another. Now the server is working, but there seems to be a problem with mysql. In directadmin in MYSQL Management i see this ...
2
votes
0answers
105 views

404 not found error on apache2 [duplicate]

I have installed apache2, actual php version, mysql server and vsftp on my new Ubuntu server. I also installed wordpress and gave the user www-data all rights for /var/www/* and put it to 755. I ...
0
votes
1answer
3k views

Unable to Login as root after mysql service restart

I installed mysql on Ubuntu 14.04 LTS like: sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql after completely removing mysql with: sudo apt-get remove --purge mysql-server ...
1
vote
2answers
831 views

What does mysql -u root -p mean while logging in?

I am new to using Mysql and I do not understand what does -u and -p imply?
0
votes
2answers
3k views

Not able to uninstall MySQL with apt-get

I had downloaded the generic Linux 64 bit MySQL 5.6.17 TAR archive from http://dev.mysql.com/downloads/mysql/ and installed on my 64 bit Ubuntu 14.04, following the instructions at ...
0
votes
0answers
70 views

Configuring mysql-server-5.5 (amd64) hangs during installation

I run sudo apt-get install tasksel then I choose LAMP Server then I've been waiting to finish the configuration and when it comes to 81% which is Configuring mysql-server-5.5 (amd64) the ...
0
votes
1answer
971 views

“'Access denied for user 'root'@'localhost'” when trying to do commands

The other day I was using MySQL on my local database fine from the terminal. However, when I rebooted the next day and tried to use it, I get the following error for just about EVERYTHING related to ...
1
vote
0answers
100 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) ...
0
votes
2answers
1k views

ERROR 1064 (42000) creating table MySQL

I try to build my own website, and at my website I ask people to enter their name and write a little story. When they are done, they hit submit, and it sends the information to my database. I work ...
1
vote
1answer
176 views

MySQL wont start with XAMPP

I have installed XAMPP on my Ubuntu 14.04 and everything works but not MySQL. MySQL is installed and works just fine with workbench but not when I try to reach it with a installation of Magento. ...
0
votes
0answers
55 views

Can I restore mysqldump to a master-master replicated server?

Suppose I have two servers A and B replicating each other(Master-Master). I think all the permissions such as 'grant replication slave','CHANGE MASTER TO MASTER_HOST' are storing in the database ...
1
vote
1answer
90 views

mysql won't be installed on ubuntu

i tried to install apache on ubuntu, and worked, i tried to install php5 on ubuntu, and thats worked too. but if im installed mysql, it wont be installed, i didnt know whats going on, i'm new to ...
0
votes
0answers
68 views

How to solve Critical errors in mysql proxy?

I have installed the mysql proxy in ubuntu.And when i give mysql-proxy command,I get the following errors (critical) admin-plugin.c:569: --admin-username needs to be set (critical) ...
0
votes
0answers
53 views

“Error:Unknown option -D” while Simple Query Interception

I am working on MySQL proxy using lua.So i am trying for simple query interception.Using this link,i have done the following. I created a file example.lua,with the following code function ...
0
votes
0answers
25 views

How do I connect a mysql client? [duplicate]

I'm trying to run mysql in Ubuntu by running mysql -u root -p in the terminal and getting this error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
0
votes
1answer
37 views

Quick way to dump a Wordpress database without digging through configuration files?

I've got a load of Wordpress sites to move around and modify this afternoon. Yay. Like any good developer, I want to back up things before I Hulk-out and break everything. The site's files are mostly ...
3
votes
1answer
2k views

Unable to re install mysql on Ubuntu 14.04: Dependency problems

Ubuntu Unity 14.04 LTS with all lenses removed, except files. (Hate the dash.) I have a LAMP system for web site development. I want to put all my data files in a particular partition that I can ...
1
vote
1answer
111 views

Shutting down ALL services (server backup)

I am running Ubuntu server 12.04 LTS. After many trials and errors, the backup strategy I have selected resorts to using TAR (mostly because I was unable to find a tool to backup/restore dovecot ...
0
votes
1answer
1k views

sometimes Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

I've got my application up and running, with rails on my ubuntu VPS in Linode with mysql. here's the version of mysql: mysql Ver 14.14 Distrib 5.5.35, for debian-linux-gnu (x86_64) using readline ...
0
votes
0answers
88 views

PHP Mysql connection works but no data can be displayed

I wrote this simple php script that just to import basic information from mysql table. As a result, not even a error message, but a blank screen. Something to do with the PHP - Mysql connection, but ...
1
vote
0answers
17 views

How to install MySQL 5.6 in Ubuntu 14.04 Desktop? [duplicate]

Which are the steps to install MySQL in Ubuntu 14.04 (Trusty Tahr)?
1
vote
1answer
2k views

MySql Not starting even when status is ok ubuntu lampp

I am a Newbie to Ubuntu. I just installed the xampp Linux version through xampp-linux-1.8.3-4-installer.run file. Following are the commands that I used: cd /home/sammy/Downloads sudo chmod +x ...
0
votes
0answers
115 views

How to use NTFS media drive as mysql data directory in Ubuntu 14.04

I want to use my NTFS drive (local/logical) as MySQL data directory. Directory: /media/omar/Coding/mysql/data. I have added the following line to /etc/fstab to auto mount the drive. UUID=DriveID ...
1
vote
1answer
55 views

phpmyadmin connect using computer name?

I use phpmyadmin to connect to a remote server for Windows machine. I have to use the IP address and not the computer name. Is it possible to use the computer name to configure a connection to a ...
1
vote
0answers
181 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 ...
1
vote
0answers
75 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 ...
0
votes
1answer
199 views

Compiling the mysql_fdw for postgresql?

I'm attempting to compile the MySQL Foreign Data Wrapper for Postgresql 9.1+, on Ubuntu 12.04 LTS and having a fair bit of trouble getting it to work. So far I've managed to use git to download the ...
2
votes
1answer
2k views

unable to create database due access denied

I just logged in to Ubuntu 12.04 as a normal user (vivek) and opened the terminal to create a database, I wrote: create database Hello; and the error I had is: ERROR 1044 (42000): Access denied ...