Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

-1
votes
0answers
31 views

Getting following errors while installing mysql server [on hold]

Got the following error while installing mysql server, Errors were encountered while processing: /var/cache/apt/archives/mysql-server-5.5_5.5.41-0ubuntu0.14.04.1_i386.deb E: Sub-process ...
0
votes
0answers
7 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
1answer
112 views

Ubuntu 14.04 Error when compile PHP 5.6.3

I did everything right with the installation of all dependencies for Apache2 and PHP i think. First I installed a clean Ubuntu 14.04 with all actual updates. Then I installed with "apt-get build-dep ...
53
votes
4answers
346k views

How do I start/stop mysql server?

I try find in internet some article where describe how correct start -stop mysql server. I find this article: How to start/stop MySql server on Ubuntu 8.04 | Abhi's Blogging World I run this ...
0
votes
1answer
24 views

Errors /var/cache/apt/archives/mysql-server-5.5_5.5.40-0ubuntu0.12.04.1_amd64.deb

After some messing around and uninstalling mariadb-server, I have problem installing mysql-server: root@serv:# apt-get install mysql-server-5.5 Reading package lists... Done Building dependency tree ...
0
votes
0answers
4 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.
2
votes
2answers
979 views

How to Drop-In replace MySQL with MariaDB?

I already have several MySQL DBs running on my Ubuntu 14.04 Server, and I would like to migrate these as smoothly as possible to the compatible MariaDB. I'm also using PHPMyAdmin. Is there a different ...
1
vote
6answers
2k views

How to install Ruby on Rails and MySql?

How to install Ruby on Rails and MySql on my Ubuntu 10.04 OS?
1
vote
1answer
52 views

How to deploy: Mezzanine + MySQL

So, here is a question: How to deploy Mezzanine, a Django CMS, locally with MySQL instead of default SQLite? What is the exact recipe?
0
votes
0answers
17 views

mysql database master - slave replication, where the master ip address is behind a nat [closed]

i am trying to do a mysql database master - slave replication, the master is a local server while the slave is a server on the cloud with a public ip address. The challenge i am going to face is the ...
0
votes
1answer
43 views

unable to uninstall package phpmyadmin / E: Sub-process /usr/bin/dpkg returned an error code (1) [closed]

currently I try to edit my local mysql database with a phpMyAdmin, when trying to create getting below error: **Could not save recent table #1142 - INSERT,DELETE command denied to user ...
1
vote
2answers
5k 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
2answers
73 views

Wordpress can't upload files

I have installed LAMP stack and Wordpress on a local apache2 server using the tutorials here- ...
-1
votes
1answer
8k views

How can I use Mysql command line client in Ubuntu 12.04?

I just upgraded Ubuntu 11.10 to 12.04 (installed within windows 7) and during installation the process asked me to set my Mysql root password. According to Ubuntu Documentation, Mysql server is ...
0
votes
0answers
23 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
16 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 ...
1
vote
3answers
87 views

How to fix dpkg error (1)

To be honest i'm not using Ubuntu but Debian (7.8), but as the commands are almost alike and this doesn't seem like an OS related problem to me, I figured I'd ask it on this glorious forum. I'm ...
9
votes
2answers
3k views

Can I share MySql database files with Windows on dual boot?

I'd like to use in both Ubuntu and Windows (dual boot) my MySql database files residing on a NTFS partition. Will it work? Any gotchas?
1
vote
1answer
10k 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
0answers
16 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: ...
4
votes
2answers
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 ...
3
votes
1answer
6k 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
1answer
15 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
4k 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 ...
-1
votes
0answers
18 views

Segmentation fault error from cron [closed]

i'm using Ubuntu 10.04.4 LTS version and Mysql version 5.1.69. By using Mysql Admin, i scheduled auto backups of Mysql database. in cron file following line is created and Mysql backups are not ...
0
votes
1answer
35 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 ...
1
vote
1answer
49 views

Mail Server Can't Receive Email But Can Send Email - Postfix, Dovecot, MySQL

I have server where I want to set up a mail server to let me receive and send email from my domain. I'm currently having a problem where while I am authorized to send email from the server, but ...
0
votes
0answers
46 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 ...
4
votes
2answers
2k views

Mysql couldn't write to /tmp then failed to restart

I was running orthomcl program which uses mysql. This program has operated just fine on the same computer before. This time I had an error message. DBD::mysql::st execute failed: Can't create/write ...
2
votes
2answers
8k views

How to downgrade PHP from 5.5.9 to 5.4 in Ubuntu 14.04 (Installed with LAMP)

I need to downgrade my PHP version from 5.5.9 to 5.4 (using Ubuntu 14.04), because I have a code that's using mySQL (which is deprecated in 5.5.9), and I cannot change that code. Is there a way to do ...
1
vote
1answer
376 views

Error installing mysql server on Ubuntu 14.04

I am getting error installing mysql on ubuntu desktop 14.04 ( 64-bit) I used following command sudo apt-get install mysql-server It asked me for password ( and verfication ) and ended on follwing ...
1
vote
2answers
61 views

MySql server not recognizing correct password

I have installed MySql server on Ubuntu 14.04 LTS. I have prior experience to it too. But whenever I login, using mysql -u root -p and after entering password it says: ERROR 1045 (28000): Access ...
1
vote
1answer
43 views

Transfer a MYSQL database file from Windows (WAMP) to Ubuntu (LAMP)

My Windows computer is broken and I cannot do anything with it. I managed to get access to the hard drive and I am moving some websites I'm developing but I need the database that is located in: ...
21
votes
4answers
186k 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 ...
4
votes
2answers
841 views

Is there a Linux equivalent to LinqPad?

I've recently been finding myself writing more SQL, on Windows with MSSQL and LinqPad and while I want to experiment on Ubuntu to get more of a handle on databases and I have no love lost for MSSQL, ...
2
votes
4answers
6k views

Can't install MariaDB 5.5 or 10 in Ubuntu 12.04. MYSQLD Failed to start?

I tried o install MariaDB on my Ubuntu 12.04 server. First it gave dependency issues and I fixed it by following this question : ...
1
vote
1answer
2k views

How can I activate MySQL Database Server?

I have a problem with my xampp that's installed on Ubuntu 12.04 64-bit. After successfully installing my xampp server, I do get access to the lampp server which further indicates that the mysql ...
0
votes
2answers
81 views

Not able to install, remove or update anything from software center

I'm having a bad time I guess. Everyday I'm facing new problems. My current problem is - I am not able to install, remove or update anything from software center. Also, sudo apt-get install -f is ...
3
votes
2answers
3k views

Making Apache secure on Ubuntu 14.04

I am wanting to host a small site at home and have installed Apache etc like this : sudo apt-get update sudo apt-get install tasksel sudo tasksel install lamp-server That all worked and everything ...
1
vote
2answers
40 views

Is it possible to have to MYSQL servers running on one physical server?

I have a fast server with 8 CPU cores (and enough RAM). However this does speedup the MySQL-database, it does have its limits. So, I was thinking to setup a second Mysql-server on the same server. Is ...
0
votes
3answers
10k views

accessing MySQL using terminal in Ubuntu 13.04

accessing phpmyadmin db from terminal now in ubuntu 13.04 i firstly installed mysql server with sudo apt-get install mysql-server mysql server version 5.5 now in terminal i can check if it is working ...
0
votes
1answer
47 views

Using mysql in C programming [closed]

I installed ubuntu on a virtual machine.There,I installed mysql server(sudo apt-get install mysql-server) .This worked, because I could acces mysql-u root -p password. After that,I did : sudo apt-get ...
2
votes
1answer
147 views

How to update MySQL Server, MySQL Client and phpMyAdmin to the latest stable versions on my local machine running on 64-bit Ubuntu 12.04 LTS?

I'm using 64-bit Ubuntu 12.04 LTS on my machine. I've already installed LAMP server on my machine. I'm using following Apache HTTP Server version. I got following information after I type following ...
3
votes
3answers
14k views

phpmyadmin throws a 404 on opening

I have installed php5 and phpMyAdmin from the Ubuntu Software Centre on a fresh install of Ubuntu 13.04. when I enter localhost in my browser the following is displayed: It works! This is the ...
-1
votes
1answer
41 views

XAMPP Ubuntu - How would i import Employees Database into Mysql

I am new to linux and programming so any help is appreciated... I have downloaded the Employees sample database from: MySql Sample Database It has given me a .tar.bz2 file type, When i open ...
0
votes
2answers
292 views

Is there a GUI for Apache, MySQL just like XAMPP for Windows?

I know how to install Apache, MySQL, PHP ..etc But I do not want Apache and MySQL to start at boot time. I also do not want to start them manually using the terminal. I am looking for a GUI program ...
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 ...
-1
votes
2answers
44 views

cannot install php5-mysql

I have ubuntu 32bit server (14.04), running php5, I am trying to install php5-mysql but I get a dependancy error. How can i fix this? ~$ sudo apt-get install php5-mysql Reading package lists... Done ...
0
votes
0answers
11 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
23 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 ...