Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

1
vote
1answer
18 views

where to save your files of php in ubuntu to load on server?

How to save our php files so that we can load on our server . I have installed apache2 , php, and mySql . also I don't know how to connect these 3 so that I can simply work on my text editor. Please ...
1
vote
2answers
6k views

phpMyAdmin - Display all queries

I have installed a fresh desktop with ubuntu quantal and the following packages versions: MySQL: 5.5.28-0ubuntu0.12.10.1 Apache: 2.2.22 (Ubuntu) phpMyAdmin: 3.4.11.1deb1 I would like ...
0
votes
1answer
19 views

Reinstall of mysql server hangs

I am trying to reinstall mysql-server-5.5 because mysql server would not start. I purged everything but the install fails I am trying to reinstall using sudo apt-get install mysql-server-5.5 and it ...
0
votes
1answer
20 views

How to add apache2 , php and mySql to eclipse?

I'm using Ubuntu 14.04 ,i'm new to Ubuntu,I already installed apache2 , php and mySql . Now I want to add these to eclipse so that I can work on this IDE . Please help me I will be glad if you provide ...
2
votes
3answers
19k views

mysql server start failed

I am running ubuntu server. When I tried to login to mysql(which was running),I got the following error ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
-1
votes
1answer
11 views

Connect to mysql on another device [duplicate]

I have two device on my network LB (192.168.1.10) and RP1 (192.168.0.20) I am wanting all the MySQL stuff to be hosted on the LB and all the web stuff to be hosted on the RP1. I have installed ...
71
votes
12answers
13k views

What's the easiest way to set up a LAMP stack?

I set up a new VPS instance of Ubuntu and am wondering what the easiest way is to get up and running with a basic LAMP stack (i.e. which packages are required, which configuration options need to be ...
11
votes
4answers
43k views

how to reinstall mysql?

A software upgrade broke, among other things, mysql and I have not been able to get it back up yet. Suspected cause: I had a near-full boot disk; the upgrade filled up the disk before completing and ...
1
vote
1answer
35 views

Installing MySQL on Ubuntu creates kworker/systemd-udevd blocked for more than 120 seconds

I've tested it twice. First time was on Ubuntu 12.04 with MySQL 5.5. Now I've tried it on Ubuntu 14.04 and MySQL 5.6. Both were fresh installs. Right after MySQL finishes installing, I begin to get ...
0
votes
1answer
14 views

Major Server Issue

lately I have been loading my website, and almost every time I do (once or twice a day) the message: "Error establishing a database connection". I have resolved it temporarily by stopping and starting ...
1
vote
2answers
24 views

How to connect to db4free database using 'mysql' command from the terminal

I am running MySQL 5.5 on Ubuntu 14.04. I can open and work with local databases using mysql in the terminal. I can also run phpMyAdmin and access the database on db4free.net on the browser. However i ...
41
votes
13answers
113k views

“Failed to spawn mysql main process: unable to execute: No such file or directory”

I'm a newbie on MySQL ground so bear with me. I've just finished upgrading 11.10 to 12.04. Everything seemed to work without any hiccups and all my software and settings are working fine. Apart from ...
3
votes
1answer
7k views

“Can't create test file /var/lib/mysql/user-desktop.lower-test”: How to run mysql server on Xubuntu 13.04 (kubuntu-desktop)

I have downloaded and unpacked MySQL 5.6.12 to /opt/mysql/server-5.6. I want to use this db instead of pre-installed 5.5 version. But neither version works. When I want to start a server with mysqld ...
0
votes
0answers
9 views

Thunderbird password error when connecting to Linux Ubuntu Server with MySQL, Postfix, Dovecot

I'm trying to build a server that can host email and allow me to connect into the email server from thunderbird. I've followed these instructions ...
1
vote
6answers
12k views

Upstart can't start MySQL

After an installation of MySQL, I get a few errors and I can't run the MySQL daemon. I've tried uninstalling and reinstalling several times, and I'm not sure what's going on. Here's a snippit of what ...
0
votes
1answer
16 views

remove the mysql server

root:~# sudo apt-get --purge remove mysql-server Reading package lists... Done Building dependency tree Reading state information... Done You might want to run 'apt-get -f install' to correct ...
4
votes
3answers
8k views

'Unable to set password for the MySQL “root” user' on a Openvz VPS

I'm trying to install mysql server on my Openvz based VPS running Ubuntu 13.04 64bit and i keep getting this error at the install. I tried multiple times and i also re installed the os with no change ...
0
votes
0answers
23 views

MySQL probram in MSSQL web application

I have this problem after I install MySQL database & connector. This problem occur when I load my program at my company that only use MSSQL database. Authentication to host '' for user '' using ...
1
vote
3answers
899 views

Having a problem to send message to gmail from our mail server

We use Ubuntu Server and in a days I have installed and configured Postfix+Dovecot+MySQL as it is explained here. From that tutorial I escaped creating certificates and antispam application. Right now ...
0
votes
0answers
32 views

to install numpy i get the following error of unmet depedency

While installing the numpy of python I get the following error: Reading package lists... Done Building dependency tree Reading state information... Done You might want to run 'apt-get -f ...
9
votes
6answers
29k views

How to configure phpMyAdmin to access multiple servers?

What is the Ubuntu way to configure phpMyAdmin so that I can use it to administer multiple MySQL servers? The database parameters are set in /etc/dbconfig-common/phpmyadmin.conf, but there's only ...
2
votes
1answer
19 views

How can I set a symlink from /tmp/mysql.sock?

I've tried to set a symlink from /tmp/mysql.sock -> /var/run/mysqld/mysqld.sock however whenever I try to do it using the following command: sudo ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock ...
-1
votes
1answer
21 views

Recommanded step for Apache and mysql Performance tuning

I googling lots of sites and forums to solve issue but i didn't get result as my expectation. I installed successfully Ubuntu 14.04 LTS on ProLiant DL360 hardware with LAMP environment. Hardware ...
-1
votes
0answers
27 views

I try to install mysql-server but following errors

i tried to install mysql-server but got the following errors. Reading package lists... Done Building dependency tree Reading state information... Done You might want to run 'apt-get -f install' to ...
0
votes
0answers
14 views

I can't restore csv file on ubuntu but restored in windows OS

I have program which creates csv file as backup. When I use my program in windows OS restore works fine I migrated my compiled program on Ubuntu 14.04.2 LTS and with support of mono it works ...
0
votes
0answers
31 views

mysql installation fails

I am trying to install mysql 5.5 / 5.6 on ubuntu 12.04. Each time the installation asks to specify the password then fails with the following error: An error occurred while setting the password ...
0
votes
1answer
5k views

mysql: unrecognized service (apparmor)

Many questions on this point but I couldn't any help yet. Mysql was working then I tried to move mysql database directory as (in this ...
0
votes
2answers
3k views

Changes for upload_max_filesize, memory_limit & post_max_size in the php.ini aren't affect

I'm trying to increase the upload_max_filesize etc in order to import bigger files with PHPMyadmin. I have changed the php.ini and restart Apache. I can see the changes on the PHPMyadmin import ...
0
votes
1answer
45 views

Unable to reinstall mysql on Ubuntu

Linux newb, so please be gentle. Tried to start mysql using mysql -u root -p and I got the following error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
0answers
17 views

MySQL 5.5 server awkward error 1146

I am a new user of both Ubuntu and MySQL. I wrote a .sql file using gedit, and when I try to load it the MySQL using source /path/to/file the tables are created, but it doesn't insert data into the ...
1
vote
3answers
4k views

Postfix + Dovecot - not receiving mail in vmail directory

i have been spending countless hours on this and now i figured id come to the 'internet' for help. I have installed a new install of postfix + dovecot + mysql. Right now, i am able to receive email ...
-1
votes
0answers
18 views

can i install mysql server and apache without starting them? [duplicate]

I am installing them in a chroot so I don't want to start them after installation. Thanks a lot.
1
vote
1answer
11k views

How to deal with MySql ERROR 1133 (42000): Can't find any matching row in the user table?

I am constantly get the following error message: 1045 Cannot log in to the MySQL server I have tried the following: sudo service mysql stop (Went fine) sudo /usr/sbin/mysqld ...
0
votes
1answer
315 views

How do I set up PHP and MySQL cronjobs on Ubuntu 12.04 (Precise Pangolin) server?

I just made a LAMP install and got SFTP working. My question now is: How do I set up cronjobs on Ubuntu server? I need to make some cronjobs for my PHP/MySQL application. I look for un-activated ...
0
votes
0answers
33 views

How to run the MySQL on Ubuntu

i tried the command mysql o/p-ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) and sudo netstat -tap | grep mysql o/p=(Not all processes ...
1
vote
1answer
5k views

why doesn't mysql create the pid?

mysql starts fine, everything is working as expected, but there is no pid file where my.cnf says it should be, the .sock is there this is the relevant section of my.cnf [mysqld] user = ...
-1
votes
0answers
50 views

Package mysql-server-5.5 is not configured yet.. I am using nethunter in oneplus one

root@kali:~# apt-get install mysql Reading package lists... Done Building dependency tree Reading state information... Done E: Unable to locate package mysql ...
0
votes
1answer
19 views

cant start xamp it gives error message like this

Starting XAMPP for Linux 1.5.3a... /opt/lampp/share/lampp/phpstatus: line 4: /opt/lampp/bin/php: No such file or directory XAMPP: Starting Apache with SSL ... XAMPP: Error 127! Couldn't start Apache! ...
0
votes
0answers
22 views

Adding mysqli to php without recompiling it

I have php compiled and installed in a nonstandard location. I recently encountered an error: Fatal error: Class 'mysqli' not found perhaps because I configured php without --with-mysqli. I added ...
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
1answer
51 views

MySQL will not start

Well, I seem to have totally broken MySQL, possibly through a combination of recently trying to upgrade mysql workbench, which needed me to install some mysql-apt-config package, which broke my usual ...
2
votes
3answers
5k views

Mysql strange installations problems (logger: command not found)

This problem is really strange, I have tried many ways to solve but nothing worked. My last output was: Reading package lists... Done Building dependency tree Reading state ...
1
vote
3answers
11k views

mysql problem '/var/run/mysqld/mysqld.sock'

I got this error on my php script with db: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) and on phpmyadmin: #2002 Cannot log in to the MySQL server What is ...
1
vote
1answer
37 views

How to execute a number of lines using xargs

I have a large sql dump that has 1 insert statement per line. I want to be able to pipe this to xargs so that I can slow down the writes. Basically I want to execute a number of lines, sleep, then ...
22
votes
4answers
205k views

How to change root password for mysql and phpmyadmin

I've set up mysql and phpmyadmin and chose not to set a password when installing hoping that once set up i could login with root and no password but i get the following error from phpmyadmin: Login ...
0
votes
0answers
27 views

MRBS Installation

I am trying to install MRBS on my Ubuntu 14.04 machine using these instructions I have reached step three, which is to create my data base. The instructions say the following: Open a terminal ...
0
votes
1answer
3k views

Turn off MySQL --skip-grant -tables

I reset my root mysql password with the following instructions: (Works for Ubuntu as well) http://www.debian-administration.org/articles/442 But now I can't turn off mysqld_safe --skip-grant-tables. ...
0
votes
0answers
4 views

Start mySQL with AppArmor on reboot

When my Ubuntu server (hosted by Rackspace) is rebooted/restarted, mySQL starts automatically as evidenced by phpMyAdmin working properly. However, my PHP code does not appear to work. When I manually ...
8
votes
1answer
2k views

Package upgrade hangs forever on mysql-apt-configure [closed]

Yesterday it got stuck with an update for MySql. The mysql-apt-config didn't finish for ours so I had to shut down the machine in the end. Today it suggested the same update again, but told me that I ...
0
votes
0answers
19 views

Compiled mysql conflicts with already existing mysql

I have just installed mysql from source and used a paco wrapper to see the file copy locations for "make install". As per the paco log, I have the following : /usr/local/mysql/lib/libmysqlclient.a ...