Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
17 views

Using mysql in C programming [on hold]

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 ...
0
votes
1answer
64 views
+50

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 ...
2
votes
3answers
13k 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 ...
0
votes
1answer
15 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
272 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
19 views

mysql in lamp-server doesn't work

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
2answers
12 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
8 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
14 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
44 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 ...
1
vote
2answers
4k views

Cannot install mysql-server-5.5/the following packages have unmet dependicies

I'm a newbie here so please bare with me. I'm using ubuntu 14.04. I tried entering mysql with the following command: mysql -u root -p and I got the following message: The program mysql can be ...
0
votes
1answer
25 views

MySQL messed up apt-get?

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
2answers
32 views

MySQL-Python-Web good Tutorials anyone?

does anyone know any good tutorial videos or webpages that can teach me how in a linux environment create a mysql db then use python to access the mysql db and create a webpage using python to display ...
0
votes
0answers
24 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
2answers
2k views

phpmyadmin not found

I am using ubuntu 14.04. I have made setup LAMP by going through step by step what in this link. For apache I mean http://localhost all the files are working fine . But when I am doing ...
0
votes
2answers
962 views

Automatically deleted MySQL database table when restart server

I installed LAMP server on my Ubuntu 12.04 Server PC. I changed the database storage location using my.cnf. After I changed the location it's working fine. But if I restart my MySQL database is ...
0
votes
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
0answers
11 views

unoconv cannot connect or start listener without sudo

I'm working on a website for school on the school server. My website uses unoconv. It was working up until today for some reason. Basically what is happening is that if i run this command in the ...
0
votes
1answer
11 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
1answer
215 views

How to upgrade softwares from currently installed LAMP on a 64-bit Ubuntu 12.04 LTS system? Please provide me the step-by-step instructions

Someone had installed LAMP on my machine almost two(2) years back. I got this machine since last six(6) months. The LAMP is working fine for all of the PHP project work I do. But the issue is all the ...
0
votes
0answers
16 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
12 views

standart apache installation on localhost is not visible outside the localhost, right?

Iḿ new to ubuntu and install apache2 php and mysql with this instructions: enter link description here As far as i know from windows, default xampp installation for example runs only on localhost, ...
2
votes
3answers
204 views

How to deploy: ubuntu | apache | python | C++ | mysql [closed]

What if you want to make a non trivial web site and/or web service? How to deploy production server Apache with python for frontend and C++ for backend and MySQL for persistance? What glue should ...
13
votes
1answer
10k views

how do I stop automysqlbackup throwing LOCK TABLES error?

How to stop automysqlbackup's cron.daily script -- as installed and configured from apt-get install automysqlbackup -- throwing the following error: mysqldump: Got error: 1142: SELECT,LOCK TABL ...
0
votes
1answer
26 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
31 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 ...
25
votes
6answers
50k views

Where are mysql-admin and query-browser?

In terminal I run next commands: sudo apt-get install mysql-server sudo apt-get install mysql-admin sudo apt-get install mysql-query-browser With first command - all ok. But for latest two ...
0
votes
0answers
18 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.
4
votes
2answers
7k 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
9 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.
6
votes
2answers
4k views

unable to reset root password of mysql

I need to reset the root password of my local mysql installation but it woudln't let me. I've tried this: $ sudo /etc/init.d/mysql stop * Stopping MySQL database server mysqld ...
2
votes
1answer
591 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 ...
0
votes
0answers
44 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 ...
20
votes
3answers
32k views

How to keep apache and mysql from starting automatically

Is there a way to make apache and mysql not run automatically on startup? Currently, whenever I boot my machine, they start automatically and run in the background. I am using Ubuntu 12.04.
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
2answers
32 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 ...
3
votes
1answer
5k 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 ...
3
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 ...
0
votes
0answers
105 views

Is there a way to set up zPanel or webmin without uninstalling LAMP first?

I set up my server manually and am pretty happy with it. It's been a job of months, chipping away at it every day, and at this point I don't want to reinstall LAMP. But all server management software ...
0
votes
1answer
13 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
15 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 ...
4
votes
3answers
73k views

ERROR 1045(28000) : Access denied for user 'root@localhost' (using password: no )

I got a problem with mysql server Actually i am not sure im tring to install queXS cati app on my ubuntu desktop i installed mysql server and php5 and when im trying mysql -u root it says ...
0
votes
0answers
14 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
26 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
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
vote
2answers
8k 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
vote
0answers
19 views

'tasksel install lamp-server' verses 'apt-get install lamp-server^' [duplicate]

Is there a reason why 'tasksel install lamp-server' or 'apt-get install lamp-server^' is better than another when setting up a fresh lamp server (or other group install)? Are they really any different ...
0
votes
0answers
10 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
23 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
1answer
45 views

Hosting website from my computer using godaddy?

I have an Ubuntu 14.04 OS and I have a website that I have been working on with the apache2 configuration and the mysql database, and I decided that I would like to upload this to the internet. So I ...