Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
305 views

How do I setup php and mysql cronjobs on ubuntu 12.04 server?

just made a lamp install adn got sftp working. My question now is how do I setup cronjobs in ubuntu server? I need to make some cronjobs for my php/mysql application. Look for un-activated users in ...
0
votes
2answers
129 views

I am trying to check the mysql bind address int the terminal but keep getting error can someone help?

I am trying to check the mysql bind address in the terminal using the command cat/etc/hosts | grep localhosts that I got offline, but I keep getting a bash: cat/etc/hosts: no such file or directory ...
0
votes
1answer
95 views

Speed up reading/writing partition

My MySQL program is on /. If I move my databases to a partition (a separate hard-disk drive) mounted on /tee, then reads and writes (MySQL queries) take an exceedingly long time: many times more than ...
0
votes
1answer
335 views

After removing a folder (apache2 I think) I'm having PHP and LAMP trouble

When I go to phpmyadmin it says: The mysqli extension is missing. Please check your PHP configuration. <a href="Documentation.html#faqmysql" target="documentation"><img src="themes/dot.gif" ...
0
votes
2answers
3k views

PHP Fatal error: Call to undefined function mysql_connect() [duplicate]

I'm trying to connect my PHP page to MySQL database, but I'm getting this error : PHP Fatal error: Call to undefined function mysql_connect() I'm working on Ubuntu 11.10 MySQL 5.5 and PHP 5.3. I ...
0
votes
1answer
2k views

Xampp : http://localhost/xampp/splash.php :english : nothing happens

After I start Xampp on my Ubuntu 12.04 I go to the localhost and I come to the site, where all languages are listed .... when I click any of these languages nothing happens. Follow steps are already ...
0
votes
2answers
672 views

Mysql server installed but not running

I tried to install mysql 5.6.12 using the following procedure # Preconfiguration setup shell> groupadd mysql shell> useradd -r -g mysql mysql # Beginning of source-build specific instructions ...
0
votes
0answers
27 views

Unable to install MYSQL Natty-security issue [duplicate]

I am running a Ubuntu 11.04 on my system. Trying to uninstall mysql server from the terminal: sudo apt-get install mysql-server But it fails with the following set of errors: Reading package ...
0
votes
1answer
337 views

uninstalling mysql from ubuntu

I installed mysql in my system using ubuntu12.10 by tar.gz file. Now,I wanted to remove it from the system,please suggest me the ways to uninstall it. Thanks in advance
0
votes
1answer
140 views

Trouble starting mysqld on mysql cluster

I set a cluster using mysql-cluster-gpl-7.2.12, first it was working fine but suddenly started to fail. I can start the nodes (ndbd) but when I try to start mysqld (API), it shows an error it says ...
0
votes
1answer
1k views

How to Automatically synchronize phpmyadmin on two lampservers?

My setup for my website is that i have a load balancer server, and two lamp servers and on the two lamp servers i have phpmyadmin installed. I have synced the two lamp servers /var/www folders with ...
0
votes
1answer
2k views

Mysql Datadir on different hard drive

I'm currently running Ubuntu 13.04 and MySQL 5.5. I have been using InnoDB, and the default location for installation. The problem is that my main OS partition is fairly small (36GB), and I need to ...
0
votes
1answer
710 views

What won't MySQL start?

MySQL will not start, and I need some help to figure out why. $ download mysql-common [sudo] password for zero: Reading package lists... Done Building dependency tree Reading state ...
0
votes
1answer
214 views

Problem while moving Mysql DB from Windows to Ubuntu?

I was planning to move mysql DB from windows to Ubuntu. Whenever I try to change lower_case_table_names to 1 (for case insensitivity) using set query it says it is read-only variable. When I tried ...
0
votes
1answer
662 views

mysql-client-core-5.5 : Breaks: mysql-client (< 5.5.31-0ubuntu0.12.04.1)

the automatic security update broke my mysql installation and I don't understand how to fix it. As far as I can tell the packages mysql-client-core-5.5 and mysql-client are on the same versio0n ...
0
votes
1answer
769 views

Can't install apache on Ubuntu 13.04 [duplicate]

I have apache files downloaded, and I've not been able to install the, it keeps listing dependencies and when I check my list of installed packages, it lists apache2 as deinstall, I equally have not ...
0
votes
1answer
191 views

Ubuntu server boot without keyboard/monitor

Hope someone can help me with this unusual problem. I installed Ubuntu 12.04 server on a Gigabyte GA-H61M-USB3 motherboard. This all went well. I subsequently installed Apache, MySQL and PHP. This ...
0
votes
1answer
1k views

mysql-connector.jar vs mysql-connector.tar

I also have the "java.lang.ClassNotFoundException: com.mysql.jdbc.Driver" in Eclipse. I have found many tips and discussions about jdbc in Eclipse, however none of them work so far. I keep reading ...
0
votes
1answer
136 views

while installing phpmyadmin i am getting an error

while installing phpmyadmin i am getting following error E: Sub-process gzip returned an error code (100) E: Prior errors apply to /var/cache/apt/archives/php5-gd_5.4.6-1ubuntu1.2_amd64.deb ...
0
votes
1answer
277 views

.profile file not getting updated in Ubuntu 12.04, trouble installing mysql

I'm trying to install mysql in ubuntu to run ruby on rails. I was going through the tutorial at Lynda. I have successfully installed ruby, gem & rails. ruby -v ruby 1.8.7 (2011-06-30 patchlevel ...
0
votes
1answer
172 views

How to I resolve this error after trying to install mysql on Ubuntu Desktop 12.04?

I am getting the following error when trying to install mysql-server on Ubuntu 12.04 sudo apt-get install mysql-server Reading package lists... Done Building dependency tree Reading state ...
0
votes
1answer
348 views

How to check if openvpn is connected in Upstart?

I need to run a script after mysql and openvpn are started (Ubuntu for ARM). I can succesfully run the script with upstart with this .conf: # my upstart for logging boot start on (starting openvpn ...
0
votes
0answers
1k views

Install MySQL 5.6 on Ubuntu 12.10 [duplicate]

I have created a script to automatically install MySQL 5.6 on Ubuntu Server 12.10 (64bit). From all the information I gather I created the following script (different functions that's why you see ...
0
votes
1answer
105 views

How to to use one instance of mysql database in a dual boot setup

I have a duel boot machine having Windows and Ubuntu 12.10. I was using MySQL database in my Windows machine and now want to use it form Ubuntu. I installed mysql in Ubuntu and set datadir. As ...
0
votes
0answers
19 views

Installation of MySQL Server 5.5 freezes on Ubuntu 12.04 LTS [duplicate]

I try to install MySql Server 5.5 on a virtual machine running Ubuntu 12.04. After executing sudo apt-get install mysql-server I get this screen: It seems that the installation is frozen. Any ...
0
votes
1answer
210 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 ...
0
votes
1answer
464 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 ...
0
votes
1answer
62 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 ...
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
1answer
382 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 ...
0
votes
1answer
348 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 ...
0
votes
1answer
566 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' ...
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
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: ...
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/> ...
0
votes
1answer
595 views

How to make a Portable Server for ubuntu?

I want my server to be portable so it will be available everywhere when I plug it in to other ubuntu computers. Like I want to use it at school, I will just have to run a script and the server runs. ...
0
votes
1answer
2k views

MySql #2002 problem [duplicate]

Possible Duplicate: My MySQL installation is broken. How to completely reconfigure it? When i try to login in apache i get a #2002 error. When i try to login in MySQL via terminal it ask my ...
0
votes
1answer
2k views

Mysqld won't start after reboot

nothing in /var/log/mysql*. syslog shows: Oct 25 09:55:28 mx mysqld: InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 14:55:28 ...
0
votes
1answer
162 views

MySQL install error?

I'm trying to get a lamp server running on my ubuntu installation. I have SSH and Apache working without any problems. I installed MySQL with sudo apt-get install mysql-server mysql-client As usual ...
0
votes
1answer
261 views

What are the executable names of MySQL client and Admin Application (GUI)?

I've tried searching for for my MySQL client and manager using Dash Home, and cannot find them. I've tried using find on the command line, but don't know what the application names are respectively. ...
0
votes
1answer
565 views

cannot locate phpmyadmin [duplicate]

I successfully installed phpmyadmin, via apt-get install phpmyadmin However I can't find the directory for phpmyadmin, I want it to appear on /var/www/phpmyadmin so that I can use it via URL. Where ...
0
votes
1answer
522 views

After installing mysqli phpmyadmin stop loading

On Linux host 3.2.0-30-generic #48-Ubuntu SMP Fri Aug 24 16:52:48 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux phpmyadmin won't load after installing mysqlnd. I'm using php5, mysql AND mysqlnd. Maybe ...
0
votes
0answers
24 views

How to instal LAMP for Ubuntu 12.04 LTS? [duplicate]

Possible Duplicate: What's the easiest way to set up a LAMP stack? I'm studying SQL database right now and I need a mySQL server. I was guided to use a LAMP server on Linux .. but I ...
0
votes
1answer
825 views

How to restore on another Ubuntu computer a MySQL backup made by rsnapshot?

How to restore on another Ubuntu computer a MySQL database backup made by rsnapshot on an external USB hard disk? This seems to be difficult because the UID and GID of mysql differ on both computers. ...
0
votes
1answer
961 views

Forward Mysql logs to Syslog-ng

Ubuntu 10.04 I have set MySQL to log slow queries and a general mysql log. How can I pipe those files in syslog to forward to centralized logging service (which is working)? Tried: source ...
0
votes
1answer
29 views

Installed program again in the “available to install” list

I have installed MySQL server and client from Ubuntu software centre. When I search for them from the dash home, they are listed under "Apps available for download" section. (If I search and find ...
0
votes
1answer
435 views

How to access MySQL server with user password issued through LibreOffice Base frontend?

When dist-upgrading Ubuntu 11.10 to 12.04 UpdateManager asked to enter a "new" user password for MySQL. I denied 3 times. This asking was put misleadingly. I better should have entered a user password ...
0
votes
1answer
43 views

Upload breaks after 3203 Inserts

I upload a textfile with approx 30'000 lines into a Mysql-DB. The upload breaks allways after exactly 3203 lines. A splitted file with less then 3203 lines runs fine. The problem is, for sure, not ...
0
votes
1answer
166 views

xamppp lampp unistall and error

Today I installed xampp from their website and just downloaded and extracted on my linux os (using tar xvfz) command and I started it using /lampp start. everything started perfectly and I wanted it ...
0
votes
1answer
684 views

MySQL access via PHP doesn't find database

I installed apache2, php5, mysql-server, php5-mysql, phpmyadmin in that order on Ubuntu 12.04 with the Software Center. Apache and PHP works fine, no problems. Also, if I try to work with MySQL via ...