Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
280 views

Can someone make this modx .htaccess file work for me? I am trying to make friendly URLs work

I now have my ModX install working but am unsure how to edit my htaccess file so my friendly urls (trying to alias pages) can anyone help? If you can a copy of my htaccess can be found at ...
1
vote
3answers
5k views

Nohup with mysql command

I need to run in background mode some mysql-query... But how can i do this with nohup? Standartly i do: musql -uroot -p use SomeDb; Select * from blablalba; But how can i do this with launching ...
1
vote
2answers
4k views

Error configuring PHP and MySQL installed from source

I'm using ubuntu 12.04. the system requires php5.2 and mysql5.1. I installed php and mysql from source. I encountered the following problem while configuring php: ./configure \ ...
2
votes
3answers
11k views

How do I import an mdf database file into MySQL?

I have an .mdf file(which is supposed to have database). I'm using Ubuntu 12.10 . I want to import the database into mysql.5.5.28-0ubuntu0.12.10.2 (Ubuntu) as this is version I'm using for mysql.
1
vote
4answers
8k views

MySQL Workbench installation issue on Ubuntu 12.04 , 64-bit system

I am getting dependency package errors as: root@osscube:/home/abdul/Downloads# dpkg -i mysql-workbench-gpl-5.2.47-1ubu1004-amd64.deb Selecting previously unselected package mysql-workbench-gpl. ...
5
votes
2answers
2k 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, ...
3
votes
3answers
4k views

Why can't I install php-mysql?

In Windows I use Xampp. I have tried to install MySQL from the command-line and I can access MySQL through workbench software. Now if I try to run Wordpress on my computer, I get an error that "Your ...
13
votes
7answers
43k views

Unable to set password for the mysql “root” user

I am new to Ubuntu. I am running Ubuntu 12.10. I am trying to install apache,php,mysql. However I have installed apache and it is running perfectly. sudo apt-get install apache2 But when I tried to ...
1
vote
2answers
765 views

Mysql Server shuts down periodically on ubuntu

Mysql Server shuts down periodically on Ubuntu. I looked through the system log file and found the following lines in the log files i checked : Out of memory: Kill process 719 (mysqld) score 114 or ...
3
votes
1answer
855 views

root cron job not running

I am trying to configure automysqlbackup to run via a cronjob to backup my dbs nightly. When I execute sudo automysqlbackup from a terminal, the process executes as expected and creates the backup ...
2
votes
1answer
1k views

How to fix AppArmor `could not open` error when installing php+mysql?

I want to install php5-imap php5-ldap php5-curl sudo apt-get install php5-imap php5-ldap php5-curl I get this error: AppArmor parser error for /etc/apparmor.d/usr.sbin.mysqld in ...
1
vote
0answers
123 views

How do I edit the commands that start a service in Ubuntu 12?

So I am trying out GBrowse, as we will use this later on. But then, I'm getting this ------------------------------------------------------------------------------------------------ 256000 features ...
0
votes
1answer
561 views

Ubuntu 12.04 Mysql Won't Install

Error when i trying to install mysql-server on Ubuntu 12.04 AppArmor parser error for /etc/apparmor.d/usr.sbin.mysqld in /etc/apparmor.d/usr.sbin.mysqld at line 9: abstractions/mysql start: Job ...
1
vote
1answer
324 views

What is the proper way to setup an Ubuntu OpenStack instance to run MySQL?

I am attempting to create an Ubuntu instance on an OpenStack Cloud. However, the basic images don't allow for a large root (/) partition nor would that be common when deployed to public clouds. I ...
0
votes
1answer
263 views

Ubuntu 10.04 server delay when POST to mySQL

I have a Ubuntu 10.04 Server and for some reason it always seems to exhibit an intermittent delay whenever performing CRUD operations on the mySQL database. Most Post commands are executed within a ...
0
votes
2answers
563 views

Is it important to leave mysql running in the background ? Is there a gui to control processes on Ubuntu 12.04?

Im using BootUp Manager (bum) to control auto-start processes on Ubuntu 12.04. I have stopped Apache2 from starting automatically using bum. The problem is, today I have found that sql server is ...
0
votes
1answer
65 views

upgrade to 12.04, mysqld up but can't log on

Sorry if this is the wrong place to post. I upgraded to 12.04 and mysql stopped working. I re-installed mysql server package. When I try to log on to database I get: ERROR 2002 (HY000): Can't ...
5
votes
1answer
9k views

Why it can't connect to local mysql server due ERROR 2002?

I installed the mysql-server from the repositories, and wanted to change the datadir to a custom location. With the datadir set to /var/lib/mysql I was able to start the server, but to the new ...
1
vote
1answer
65 views

Failing installation of Mysql

start: Job failed to start invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.5 (--configure): subprocess installed post-installation script returned error ...
0
votes
1answer
7k 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 ...
5
votes
3answers
6k views

Debconf errors when configuring mysql-server

When I try to run sudo apt-get upgrade I get the error below. I also get similar error when running sudo reconfigure postfix, which I relly need to run since outgoing e-mail is not working any more. ...
-2
votes
1answer
18k 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
1answer
326 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 ...
12
votes
4answers
6k views

OpenSource Document Management

I'm looking for Web-based, Opensource, PHP-MySQL Document Managment for my organization with these features: Features : Full text searching Document Metadata User access previledges Document ...
1
vote
1answer
16k 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
494 views

why phpmyadmin didn't work?

When run phpmyadmin it is not working and i get this message: Not Found The requested URL /phpmyadmin/ was not found on this server. Apache/2.2.22 (Ubuntu) Server at localhost Port 80 How it's not ...
1
vote
1answer
658 views

Installed mysql but cannot login: Access denied for user 'xxxxxx'@'localhost' (using password: YES)

Installed MySQL - but not able to login with the user I created. It gives me the following error. Access denied for user 'xxxxxx'@'localhost' (using password: YES) Please help.
0
votes
1answer
376 views

How to access Ubuntu server 12.10 via hostname,

I had it working, but then installed LAMP and a few other things to set up a webserver, now PUTTY only allows connection via IP, which works, and Webmin worked with hostname as well, until now... I ...
6
votes
1answer
18k views

Can't start MySQL server if the .sock file is changed in /etc/mysql/my.cnf

I have installed MySQL server 5.5 on Ubuntu 12.04. I am trying to start MySQL server on a different sock file. By default MySQL runs on /var/run/mysqld/mysqld.sock. I am trying to run the same server ...
7
votes
1answer
7k views

Is it safe to delete preinstalled MySQL databases like INFORMATION_SCHEMA?

I just installed the LAMP server and PHPMyAdmin. Once I logged in I noticed databases already created and within them tons of tables and rows. My question of course is whether I can just delete them ...
4
votes
1answer
4k views

How do I copy MySQL databases to another Ubuntu machine?

I installed a LAMP server on my pc and created databases. Now I want to copy it to my friend's computer. How can I do this?
6
votes
2answers
8k views

PHP and MySQL not communicating

I have come to the conclusion that my PHP installation and my MySQL installation are not getting along; I’m working on making my first web page that uses MySQL for content, but after two days, man ...
0
votes
1answer
759 views

MySQL broken on localhost since update

all. After a recent 12.04 update (MySQL was updated), when trying to access my localhost site I get the following error: Database Error: Unable to connect to the Database: The MySQL adapter 'mysql' ...
-1
votes
2answers
1k views

Why does my MySQL remote-connection fail (VLAN)?

ubuntu-community! Again I have a problem with my special friend MySQL :D I have got two servers - a database-server and a web-server - who are connected via VLAN. Now I want the web-server to have ...
0
votes
1answer
4k views

Problem after mysql-server installation I cant install any thing in ubuntu 12.04.1 now

I'm not an advanced user of Linux and I tried to install work with database so I installed Mysql-server, I think I did same thing wrong so I get in trouble and now I cant install any thing and this ...
0
votes
2answers
474 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 ...
3
votes
0answers
2k views

Why can't I reinstall MySQL? [closed]

List item I've been looking all around the Internet for an answer but didn't find anything. I hope you can help me now. I have a server with MySQL. From one day to another, MySQL didn't let me ...
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 ...
2
votes
1answer
3k views

mysql show databases not showing databases that are in /opt/bitnami/mysql/data directory

I have an ebs-backed ec2 ubuntu server which is running but unreachable. There are very stupidly no recent backups. I made a snapshot of the block, created a volume, spun up a new instance, ...
3
votes
2answers
9k views

mysql not starting

I have a server running on rackspace.com, it been running for about a year (collecting data for a project) and no problems. Now it seems mysql froze (could not connect either through ssh command line, ...
4
votes
2answers
10k views

Error 1130 connecting to MySQL on Ubuntu Server 12.04

I hope this is the right place for this...I currently am running Ubuntu Server 12.04 through VirtualBox on a Windows 7 host. I am trying to connect to the VM's MySQL engine using MyDB Studio for ...
0
votes
5answers
11k views

how to stop mysql server with root

How can i stop mysql server (installed using binary installation under /usr/local/mysql)? When i go in /usr/local/mysql/bin and execute command mysqld stop i get following error message : [ERROR] ...
1
vote
1answer
93 views

When does MySQL server start when my system starts up?

I installed MySQL using apt-get ..., and when I press the power button, while my system boot up, MySQL starts automatically. But I want to know what's the time it starts exactly, and through which ...
0
votes
1answer
3k views

Offline MySQL installation (Using deb file and no internet connection)

I downloaded MySQL's installation package and ran the following command after installing a fresh Ubuntu server. dpkg -i mysql-5.5.28-debian6.0-x86_64.deb It installed fine and then I tried starting ...
1
vote
3answers
3k views

How do I setup php+My sql development environment

How do I setup php + My sql development environment in Ubuntu ?
0
votes
2answers
745 views

installing apache2, php5, mysql, phpmyadmin

I used the following commands sudo atp-get install apache2 sudo apt-get install mysql-server sudo apt-get install php5 sudo apt-get install phpmyadmin sudo /etc/init.d/apache2 restart after ...
0
votes
1answer
1k views

ERROR 1018 (HY000): Can't read dir of './depot/' (errno: 13)

I want to use of symbolic link for change path database in mysql. I create a Directory ,then create a symbolic link to this directory but when I want to use of this database get following error: ...
1
vote
1answer
116 views

Recent Ubuntu update prevents MySQL root access

I recently updated my Ubuntu (10.04 LTS) server (apt-get update, apt-get upgrade), and everything works fine, apart from the root access to my MySQL database. phpMyAdmin, CakePHP, and essentially all ...
3
votes
0answers
422 views

Another apparmor / mysql wont install

I am trying to config another instance of mysql on my present but i can't mysql_install_db --user=mysql --datadir=/var/lib/mysql2 Installing MySQL system tables... ERROR: 1005 Can't create table ...
0
votes
1answer
1k views

I can't start mysql in ubuntu 11.04

I downloaded following files of Oracle.com: MySQL-server-5.5.28-1.linux2.6.i386.rpm<br/> MySQL-client-5.5.28-1.linux2.6.i386.rpm<br/> MySQL-shared-5.5.28-1.linux2.6.i386.rpm<br/> ...