Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

1
vote
1answer
2k views

can't start mysql service anymore

I had MySQL running ... with many different databases. I install MySQL workbench today.. and was able to create any entity relationship diagram etc. Then i decided to increase the size of my ...
1
vote
2answers
1k views

install postfix and store all incoming mails in MySQL DB

i cant config. postfix correcly, could someone please help me with that? the google results i find, aren't really helping me.. its about a problem i try to solve for weeks now.. so: i need to be ...
1
vote
1answer
116 views

How to change phpmyadmin username from root to something else?

I can't seem to find a resource in the internet that explains how to do this from the command line or phpmyadmin. I'm using Ubuntu Server 13.04 in Amazon EC2.
0
votes
1answer
62 views

whats wrong with my SQL command

first of all I am following this tutorial. as they mentioned I am writing my query as: mysql> grant select -> on play.* -> to 'guest' @ 'localhost' -> IDENTIFIED BY '459459'; ...
1
vote
1answer
919 views

any way for auto-tab in mysql?

Using MySQL version 5.5 in Ubuntu 13.04.is there any way for enabling auto-completion with TAB in mysql ? I'd like to auto-tab for table names,database names,commands etc ,.
1
vote
2answers
530 views

save mysql ouput as text?

I am using Ubuntu 13.04 and installed MySQL Server version: 5.5 . All I want simply , if I doing a MySQL query then its output should have to store in a text file. How can I achieve this ? for ...
0
votes
1answer
796 views

How to uninstal MySql 5.6 and reinstall 5.5

I followed this (rtcamp.com/wordpress-nginx/tutorials/mysql/mysql-5-6-ubuntu-12-04/) to try to upgrade from 5.5 to 5.6. But I could not change the root password. I want to install 5.5 again. So I ...
9
votes
7answers
101k views

How to run mysql command from terminal?

I have the following sql command which I usually run in phpmyadmin by selecting the database, then running it in the command window. DELETE FROM `wp_posts` WHERE `post_type` = "attachment" However ...
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?
2
votes
1answer
2k views

Script to enter data from mysql database into text file

I have written a script to extract the contents of a table into a textfile. this is my code #!/bin/bash mysql -uroot -ppasswd database select * from table>textfile.txt i have changed ...
1
vote
1answer
1k views

Can not install MySQL on my Ubuntu 12.04

I had trouble installing MySQL server on my laptop. And now if i try installing anything new it gives an error message. I tried most of the sites but could not find a solution to my problem. When I ...
0
votes
1answer
7k views

Inserting data into mysql table using a script

I am trying to load data into mysql database using the following script #!/bin/bash DB_USER='my_user'; DB_PASSWD='passwd'; DB_NAME='db_name'; TABLE='rass'; INPUT_FILE='/...
0
votes
2answers
2k 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 ...
1
vote
0answers
378 views

Problem after installing phpmyadmin

I installed apache, mysql, and php on my Ubuntu 12.04 server but after logging in all I see is a white screen displaying a forward slash. Is there something else I need to configure or enable? / ...
5
votes
4answers
14k 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
1answer
1k views

Loading data into MySQL database using cron

I would like to make the loading of data into MySQL database (Ubuntu 12.04) a cron job. I have am able to do it manually using the code: LOAD LOCAL DATA INFILE re.txt INTO table rasss LINES ...
1
vote
1answer
81 views

Can not setup Mysql

I was trying to setup mysql with this command sudo apt-get install mysql-server Now i am getting this error start: Job failed to start invoke-rc.d: initscript mysql, action "start" failed. ...
1
vote
1answer
212 views

package installation error

I was trying to install mysql server 5.6 via deb file and the software installer froze and force quited. After that when i tried to install mysql via the command sudo apt-get install mysql-server ...
3
votes
1answer
11k views

What do I have to add to this iptables setup to allow mysql access through ssh?

I just want to be able to access mysql through ssh, but I don't want to accept everything as well. What's the most secure way to do this if any. Here are my rules: *filter :INPUT DROP [14:1434] :...
1
vote
2answers
3k views

Loading data into mysql database

I have a text file which i would want to load into mysql database on Ubuntu server 12.04 LTS. I have entered the data into the file trey.txt and i moved the file to /tmp directory. When i move to the ...
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/...
1
vote
3answers
2k views

How to get arp tables from switch to server mysql database using snmp

I would like to obtain ARP tables from a switch to a syslog server(Ubuntu 12.04 LTS). I have done some research on how to do it and i decided to use SNMP. I have done some research and i know that my ...
0
votes
1answer
393 views

What does Arrow in mysql require

It is my first times creating a database in mysql and i performed the following operations CREATE DATABASE logs USE logs CREATE TABLE FROM_DHCP(host varchar(35)) the result is an arrow which has ...
0
votes
1answer
266 views

Build Apache module in C

I've a problem in building a Apache c module. For compiling the module, i use the statement: sudo apxs2 -I/usr/include/mysql -i -a -c mod_aledav.c and the module seems to be compiled correctly, but ...
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
1answer
868 views

Setting up websites with Ubuntu 13.04 server and Nginx

I'm trying to setup 2 websites on my server ---> A_website and B_website I don't have a domain name registered and I just want to use the site privately so I'll be accessing it via the static IP ...
1
vote
1answer
809 views

Backup MYSQL DB on one server and restore on other, do i need the same version of MYSQL?

I backupped my old db on ubuntu 10.10 server using mysql 5.1.49 using mysqldump now I want to restore the file on my other machine, using ubuntu 12.04 server with Mysql version 5.5.32 on it. I ...
1
vote
0answers
27 views

Xampp is not working properly in ubuntu13.04 [duplicate]

I am new to ubuntu operating system and i tried the xampp installation process like the following steps.. cd ~/Downloads sudo mkdir -p /opt sudo tar xvfz xampp-linux-1.8.1.tar.gz -C /opt sudo /opt/...
3
votes
2answers
18k views

Changes for upload_max_filesize, memory_limit & post_max_size in the php.ini aren't affect

I'm trying to increase the upload_max_filesize etc in order to import bigger files with PHPMyadmin. I have changed the php.ini and restart Apache. I can see the changes on the PHPMyadmin import ...
0
votes
1answer
925 views

XAMPP(LAMPP)'s phpmyadmin throwing error #2002

I have just installed XAMPP(LAMPP) about a hour ago and I am continously searching for the error I am getting on while opening http://localhost/phpmyadmin(phpmyadmin). The screen of the error is as ...
1
vote
2answers
6k views

How to set up Apache, MySQL Servers (Ubuntu 12.04 LST)

I am hoping to get guidance on using Apache and MySQL servers on Ubuntu 12.04. I am new to Linux, and am trying to setup a "Localhost" dynamic for basic website design. In windows - I had used a ...
0
votes
1answer
625 views

Browser is not displaying the php output

I have installed lamp over Ubuntu 12.4. I am able to work with mysql through Command prompt and User Interface, but when I try to execute the php script which include HTML and MySQL statements, the ...
0
votes
1answer
3k views

12.04 - MySql won't start by using service mysql start

The only way I was able to get MySql to start was to issue: mysqld When I issued this command, it started rolling back some database transactions that were conflicted. I have tried issuing ...
0
votes
1answer
507 views

cannot upgrade kernel and mysql-server after dist upgrade

did an upgrade from 12.04 via 12.10 to 13.04. Every upgraded fine but the kernel did not. I am stuck with 3.2.0.52. I decided to leave it for the time being but now mysql did an autoupgrade and that ...
1
vote
0answers
321 views

How to set up a DNS server on ubuntu server?

This DNS server will use to access a web server/ mysql server. Scenario: DNS Server of 192.168.0.0/24 network - 192.168.0.2 domain name(dn): my.site.com redirect to 192.168.2.1 (webserver/mysqlserver) ...
0
votes
1answer
187 views

Strange message now appears when I open up my terminal

I was recently installing MySQL and everything seemed to go just fine, however, when I opened up my terminal to test a few things out, I got a strange message: No command '“alias' found, did you mean:...
0
votes
3answers
8k views

mysql error 1045(280000) access denied for user 'debian-sys-maint '@' localhost using password 'yes'

I edited deian.cnf to change the password of mysql (ubuntu server) sudo vi /etc/mysql/debian.cnf I change user=debian-sys-maint password=* to user=debian-sys-maint password=...
0
votes
1answer
541 views

How do I set up PHP and MySQL cronjobs on Ubuntu 12.04 (Precise Pangolin) server?

I just made a LAMP install and got SFTP working. My question now is: How do I set up cronjobs on Ubuntu server? I need to make some cronjobs for my PHP/MySQL application. I look for un-activated ...
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 ...
1
vote
2answers
7k views

What alternatives to MS Access exist for database management on the Ubuntu platform (LibreOffice Base isn't cutting it) [duplicate]

I have a web-based MySQL database, which is very important. I have used the MySQL Connector to allow me to use an MS Access database to query, and clean up my database, through an ODBC connection. ...
0
votes
2answers
268 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
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
1answer
9k views

How to let MySQL (mysqld) to create and write to “/var/run/mysqld” directory?

I really don't understand how all those privileges work in Linuxes. To start MySQL server mysqld program has to write its .pid files to /var/run/mysqld/ directory. But we know from FHS (Filesystem ...
4
votes
1answer
19k 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 -...
1
vote
0answers
99 views

Mount Drive at Start-up but MySQL can't see it

I'm trying to automount my drive using the following command in startup applications: /usr/bin/udisks --mount /dev/sdd1 However, MySQL fails to start when I mount the disk. On the contrary, if I ...
2
votes
1answer
2k views

How to install MySQL DB 5.6.12 (downloaded from mysql.com) on Xubuntu (kubuntu-desktop) 13.04?

I have an experience of setting up and running MySQL on Windows. It is really easy. I just downloaded .zip, unpacked it in C:\MySQL, placed C:\MySQL\bin to PATH and then ran the server with the ...
0
votes
1answer
128 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
523 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" ...
2
votes
3answers
156 views

Using existing mysql database in lampp

I'm using ubuntu 13.04 in a 32 bit machine. I have Windows 8 installed also. I have set up lampp in my ubuntu OS. Now I want to use mysql databases of Windows in ubuntus lampp. I have searched a lot ...
0
votes
2answers
6k 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 ...