Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
6k views

How to install Zend Framework 2 on ubuntu?

I'm looking for a tutorial on how to install Zendframework 2 on Ubuntu 14.04, and also a tutorial teaching how to use ZendFramework 2. Could someone help me? If it is useful to know, I'm with XAMPP ...
0
votes
1answer
440 views

Why access denied for user root right after I set up its password?

I have installed php and mysql. But cannot set the root password. This is what I've done so far: sudo apt-get install mysql-server sudo apt-get install mysql-client After that: mysql -u root -p ...
0
votes
1answer
3k views

How to install PHP MySQL extensions

I just installed a new server which comes with php 5.5. however one of my older projects requires php 5.3. So I installed php 5.3 with wget http://www.php.net/get/php-5.3.28.tar.bz2/from/a/mirror ...
0
votes
1answer
2k views

Question about multiple 'root' users in mysql's users table

+-----------+------------------+-------------------------------------------+ | host | user | password | +-----------+------------------+---------------...
0
votes
1answer
531 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
96 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 ...
0
votes
1answer
3k 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
1answer
589 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 ...
0
votes
1answer
1k views

Restoring MySQL files to new disk 14.04 - permissions?

I am rebuilding my computer with a new disk and have a backup of my MySQL db's - I have moved them to /var/lib/mysql and when I try: sudo /etc/init.d/mysql start MySQL refuses to start - the error ...
0
votes
1answer
51 views

mysql problem with login in terminal

I read many post including https://help.ubuntu.com/community/MysqlPasswordReset this one one all of method. How much time I do this I don't know. Still my problem was't fixed. I already wasted 6 more ...
0
votes
1answer
1k views

mysql error : Incorrect key file for table '/tmp/#sql_5115_0.MYI

Query failed by reason : Incorrect key file for table '/tmp/#sql_5115_0.MYI i read that it may be realted to disk space issue but i ma not sure how that is as df -h returns Filesystem Size ...
0
votes
1answer
125 views

target 'php5-mysql' is not a directory error

I'm trying to get LAMP up and running in VirtualBox for an assignment I have. I've installed Ubuntu and then Apache 2 and PHP 5. I'm using the instructions found here: https://help.ubuntu.com/...
0
votes
1answer
489 views

aptitude problem using mariadb repository on Ubuntu 13.10

I installed mariadb 5.5 on my ubuntu laptop like described here: sudo add-apt-repository "deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntu $(lsb_release -c -s) main" and it works fine so far, ...
0
votes
1answer
366 views

i want to install my sql client and server

i need to form network like "directory service" i am using ubuntu 13.10 client and 13.10 server i need to install "my sql server and client" Thanks and regards in advance
0
votes
1answer
286 views

HTML doesn't show php script on Uuntu 12.04 ( PHP5, Apache2, mysql) all are installed properly

But info.php in /var/www/ does show the info. Only PHP embedded in html doesn't show the script. please help me.. I have tried the previous askubuntu questions and didnot get anything useful so ...
0
votes
1answer
464 views

Can't run PHP script accessing my Mysql databse

I've created LAMP server in my ubuntu desktop. I've also made a sample database in Mysql having 6 columns. I can access it through the terminal. I've also created a php script for accessing the same. ...
0
votes
2answers
2k views

Mysql query browser or any Mysql gui tool in Ubuntu

I have installed Ubuntu 13.04 and now fully dependent on it. I have worked on mysql query browser in windows to run queries and procedures and programmers ,i could not find any other alternatives in ...
0
votes
1answer
63 views

Mysql/php connection

I'm a newbie to ubuntu,and im trying to connect the mysqlworkbench(database) with php5.3 if (function_exists('mysql_connect')) { echo "Good<br />\n"; } else { echo "Bad.<br />\n"; } I'...
0
votes
2answers
580 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
2answers
366 views

Ubuntu upgrade from 8.04 to 13.10 [closed]

I have a Dell Power Edgge 2950 server running Ubuntu 8.04. Now I would like to upgrade it to to the latest version 13.10. This server is hosting MySQL database and Apache server. root@server:~# ...
0
votes
1answer
35 views

can i again reinstall java on ubuntu?because both windows and ubuntu is in my system and java is configured on windows?

iam new to ubuntu. i have been working on windows. My question is can we run web application developed in windows on ubuntu? both windows and ubuntu is installed in my system java is congigured on ...
0
votes
1answer
1k views

install mysql proxy via ubuntu terminal

How do i install MySql Proxy via ubuntu terminal http://dev.mysql.com/doc/refman/5.1/en/mysql-proxy-install-binary.html
0
votes
1answer
102 views

command line syntax that will show MySQL details

Is there a command-line syntax that will show details about my installed MySQL (eg. ports, config file paths, etc.)?
0
votes
1answer
124 views

Terminal command repeated twice to work

I am very new with linux and ubuntu. Installed it in VMWare Player yesterday and I've been watching some good command tutorials. I've installed mysql and php and some stuff. I've created a database ...
0
votes
1answer
178 views

Changed apache www folder

So I changed it from /var/www to /home/John/Dropbox/www and I also did chmod 755 /home/John/Dropbox/www but it still says You don't have permission to access / on this server. I forgot how to do this,...
0
votes
1answer
758 views

replication checking shell script error

I'm trying to create a Database Replication checking script which checks master-master replication but I'm getting error while executing it. Here is the script #!/bin/bash PATH=/usr/local/sbin:/usr/...
0
votes
1answer
74 views

Backing up MySQL to UbutuOne

I use mysql as a backend for my xbmc, I also have a ubuntu one account. What is the best way to regularly back up the database to ubuntu one?
0
votes
2answers
191 views

Writing to mysql database in Ubuntu Server 12.04 LTS

I am retreiving arp tables from a switch using snmp. I can poll the tables to a text file, but i want to do it to the mysql db. this is the code i am using to poll to text file */5 * * * * root /usr/...
0
votes
2answers
198 views

Problems using mysql

I just opened mysql by typing "mysql" in the terminal. Then, I went to create a database which threw this error :- mysql> create database test2; ERROR 1044 (42000): Access denied for user ''@'...
0
votes
2answers
2k views

How to install the latest versions of LAMP componanents [duplicate]

I want to develop web applications with PHP, for that reason I need to install a LAMP system, I heard that it's good idea to use latest versions of PHP, MySQL and Apache ... so if it's possible please ...
0
votes
2answers
463 views

Will I lose mysql installation and associated databases if I reinstall Ubuntu?

I just ran into an OS issue, and I was thinking of simply doing a reinstall of Ubuntu. I was looking at the Ubuntu installation options, and I saw that I could "Reinstall Ubuntu 13.04". "Documents, ...
0
votes
3answers
700 views

GUI mysql tool for multiple databases

I have two discrete mysql databases (located in different servers). In windows, I can use odbc and ms access and query from tables residing in different databases. In ubuntu, is there a way or tool to ...
0
votes
1answer
518 views

Java Hibernate: Download MySql or LAMP

I am going to be writing a Spring based Java application and I was wondering if I should install MySql directly or should I just install LAMP. I would like to install LAMP, but would this have any ...
0
votes
2answers
3k views

How do I display an html file on a web browser in Ubuntu?

I am tasked with displaying a program on a web browser for my final project. The browser would be run from a cloud instance, and I have chosen to show an java applet that I have made. I have already ...
0
votes
1answer
452 views

g++ fails to link to libmysqlclient

I use Ubuntu 12.04 on a virtual machine on my MacbookPro. I installed build-essential, mysql-server and libmysqlclient-dev. Both commands 'mysql' and 'mysql_config' work. However, the following ...
0
votes
1answer
700 views

Bring in old databases in MySQL?

Ok, so when mysql updated a while back, it broke. It was simply not starting. So I tried fixing it, but hadn't been successful. I finally gave up, copied all the directories & files under /var/...
0
votes
1answer
1k views

Mysql very slow on (fast) development laptop

[Solved] Ubuntu 12.10 x64 new i7 laptop, mysql default installation. Importing a 6 MB dump file (a empty drupal dump made mostly of INSERT INTO statements) takes ~30 minutes, on other PC takes less ...
0
votes
1answer
332 views

Problem sharing Mysql data on dual boot machine

First of all let me say that this is a question following my attempt to do the solution on this post Can I share MySql database files with Windows on dual boot? . I was hit by an error and need help ...
0
votes
2answers
481 views

MySQL does not start up on ubuntu 12

MySQL Server does not start up on ubuntu 12. When I run the status command, the following message is displayed: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/...
0
votes
1answer
1k views

MySQL port forwarding

I am trying to help a colleague to connect to my MySQL server. However the situation is a bit special, and here's why (let's call him person A and me, person B): Person A has a PC, on which he has a ...
0
votes
1answer
2k views

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

My mysql installation was screwed up. I uninstalled and installed it multiple times. But I kept getting a hang or a error "cant connect". I now finally have it running with sudo -u mysql mysqld. How ...
0
votes
1answer
566 views

mysql does not start or work

Recently I installed LAMP with tasksel. Then I remember I issued some commands to get into the mysql console - it worked. Right now I checked - apache and php modules work perfectly. But as for mysql ...
0
votes
1answer
215 views

Which package of MySQL should I choose from the software center?

When installation MySQL in ubuntu software center There are two programs Mysql server Mysql client Whichever is chosen for the installation MySQL
0
votes
1answer
423 views

Ubuntu 12.04 MySQL 5.5 MyODBC 5.1 or 3.1 query hangs

I have been able to install Ubuntu 12.04 with LAMP MySQL version 5.5.x It works fine within linux, it allows me to connect from myodbc windows vista or windows 7 I have configured networking access ...
0
votes
2answers
4k views

Ubuntu 12.04 Mysql doesn't start on reboot; starts ok later manually

I've just installed MySql to support a mediawiki install on 12.04 64bit. Everything appears to be working ok, except that at boot-up, mysql server fails to start. This results in an error appearing on ...
0
votes
1answer
4k views

why is apt-get not install mysql server 5.5

I have mysql server 5.1 installed. I want to update it to 5.5 . I took a back up and uninstalled 5.1 using this command sudo apt-get --purge remove mysql-server* when I again used apt to install ...
0
votes
1answer
1k views

I need to install my sql server 5.1 where there is no internet connection

Please kindly help me at the following issue. Currently I don't have an Internet connection and I need to install MySQL server on Ubuntu 11.04 without any rpm packages. I have only the tar file with ...
0
votes
3answers
1k views

MySQL and PHP problems

I'm new in server-side programming. I need lampp and mysql running on my computer. I have installed mysql using tasksel lamp-server, and then install php with apt-get install libapache2-mod-php5 ...
0
votes
1answer
2k views

Unable to login using new mysql user added via phpmyadmin

On my computer yesterday I installed 12.04 and applied all updates. I have installed lamp on this system using following command sudo apt-get install lamp-server^ phpmyadmin . I created a new user ...
0
votes
2answers
4k views

innodb_buffer_pool_size not changing

I have encountered a weird problem with innodb_buffer_pool_size configuration on 5.5.23-1~dotdeb.0 (Debian): Whatever new value that I choose in my.cnf for innodb_buffer_pool_size (e.g 3G, 4G, 8000M),...