Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

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
7 views

trying to install mysql-connector for python 3

my experience is minimal with Linux so i need a little help! i am trying to install the python mysql-connector for python3.2, i was able to use pip to install it for python2.7 with 'pip install ...
0
votes
0answers
7 views

Prevent multiple login in squid authentication

I am using a custom php script that read a sql database to authenticate squid3 proxy users on a ubuntu server 14.04. However it allows multiple simultaneous logins with the same username and password ...
0
votes
1answer
12 views

How to connect .sql file to MySQL Server to work with application server

I have an information system programmed using XAMPP. It has a .sql file, in which I'm sure it is a database file. I used Ubuntu Server and installed LAMP on it. I put the info. system in the server ...
8
votes
6answers
12k views

How to stop mysql from running at boot time?

How could I stop Mysql from running at boot time? Is there any GUI for that or this must be done through console? It's Ubuntu 10.10
1
vote
3answers
19k views

how install mysql 5.6 and mysql workbench 6.0.9 on ubuntu 13.10

I am using Ubuntu 13.10 Saucy Salamander (64 bit System) . I want to install mysql 5.6 and workbench 6.0.9 on it. how i do it please describe step by step?
5
votes
1answer
2k views

MySQL 5.6 depends on client 5.5

I've installed Mysql-(server/client)-5.6 on Ubuntu 14.04 LTS server but for some programs I need mysql-client (automysqlbackup and postfix for example) root@server:~# apt-get install ...
8
votes
6answers
51k views

how to correctly install apache2, php5, mysql and phpmyadmin

What is the most correct method of installing apache 2 server, php5, mysql and phpMyAdmin? I installed it this week, and I had a lot problems without solutions, so now that I reinstalled Ubuntu 13.04 ...
0
votes
0answers
13 views

Check which services are running on the server (python script) and restart them if they have stopped?

I am trying to write a python script which shows me the services which are running on my server. The thing is that mongodb keeps going down on the server and each time it happens I have to manually ...
0
votes
1answer
34 views

Copy file from one ubuntu to another ubuntu

By using cron job I've successfully created a backup of mysql database on the Ubuntu. Below is the command under mysqldump.sh /opt/lampp/bin/./mysqldump -u root database-name | gzip ...
0
votes
2answers
22 views

apache2,php and mysql - facing problem in editing the files and loading them in browser

friends, I have installed apache2 , php and mysql but now the problem is I don't know where to write the programs and put them back into the server folder so that I can access them back.My file i.e ...
-1
votes
0answers
16 views

Have localhost with dual boot (Windows/Ubuntu) share htdocs & mysql databases with XAMPP

I just got a new machine with dual boot Ubuntu+Windows 8.1 and set up a localhost using XAMPP in a way that allows me to edit and preview the files on both OSes (so htdocs and mysql databases have to ...
0
votes
1answer
27 views

mysql-server hangs on setting password

Every time I try install mysql-server it hangs on this screen This is the case of not entering a password, but when I do enter a password it hangs on this screen after pressing OK I've been ...
0
votes
0answers
9 views

HostGator to Amazon PHP send mail not working

After I transferred hosts from hostgator to aws ubuntu, all my send mail does not work. for example when someone register's, it is supposed to send an automated email to that user. I am using X-Mailer ...
0
votes
0answers
18 views

Ubuntu 14.04 problems with mysql

My problem is when I try to install mysql-server, I get some errors during the installation. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ...
0
votes
3answers
3k views

Import error :No module named MYSQLdb

I have a problem so a connection a python to database local of MySQLdb. Message of error is: import MYSQL ImportError:No module named MYSQLdb. This is a script in python 3.4 to connection my ...
3
votes
2answers
3k views

Mysql 5.5 reinstallation 12.04

I had a broken installation of mariadb over mysql 5.5. For hours i have tried to reinstall mysql with the usage of apt-get - tried to purge, remove etc everything mysql related. Uninstalled php ...
0
votes
0answers
36 views

Installing Bacula while running MySQL 5.6

I am attempting to install Bacula (5.2.6+dfsg-9.1ubuntu3) on our server running Ubuntu 14.04 LTS. However, I am having troubles very early in the installation process. Running the command apt-get ...
1
vote
0answers
54 views

How to run php files in ubuntu?

I installed apache2, php5 and mysql. http://localhost/ url in browser shows it works. I saved a php file in /var/www/ as testphp.php. Code in the file is.. <?php phpinfo(); ?> Now on entering ...
0
votes
1answer
106 views

MySql did not install properly and now I can not use the software center or remove MySql

When I open the software center I got an error saying "New software cannot be installed, because there is a problem with the software currently installed. Do you want to repair this problem now?" ...
4
votes
3answers
8k views

Recommended testing tools to test MySQL performance?

What is the recommended tool(s) for testing the performance of MySQL 5.5 (innodb) under Ubuntu 12.04? We have purchased a new multi-cpu multi-core server to replace our current MySQL dual-core ...
-1
votes
0answers
14 views

My postfix/dovecot/mysql mail server can receave, but send mails only to me! [closed]

Please help! My (UBUNTU SERVER 14.04) postfix/dovecot/mysql can receives mails, but sends only to my own e-mail address! Here are parameters: myhostname = mycite.com alias_maps = hash:/etc/aliases ...
2
votes
1answer
40 views

mysql-client-5.5 update error

I just run apt-get upgrade and many packets should be updated. I allowed them all (question after Disk Space and verification). After the download and my configured packages Ubuntu told me from an ...
1
vote
1answer
12k 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
20 views

permission denied for mysql when compiling in CDT eclipse [closed]

I have a remote machine which I connected it by echoVNC and I access by vnc user & password. I installed eclipse CDT and I also installed mysql under the vnc user. I wrote a small program which ...
0
votes
2answers
41 views

How to insert data from text to mysql? [closed]

I get this text from router via ssh. But I want to insert user(fr-XXX) and macadress(F0:24:75:33:22:11) to mysql routerusers table. Flags: M - mac-cookie # USER DOMAIN ...
-1
votes
4answers
38 views

How to set up an environment for executing PHP files in Ubuntu 14.04?

I am coming from Windows.In Windows,i used WAMP and Adobe Dreamweaver CS 6. In Ubuntu, I am going to use Bluefish Editor. I need to setup LAMP(Linux Apache MYSQL PHP) and Phpmyadmin.Please give me ...
0
votes
2answers
5k views

Setting ServerTokens and ServerSignature in Apache

I have been following this tutorial closely http://net.tutsplus.com/tutorials/php/how-to-setup-a-dedicated-web-server-for-free/comment-page-8/#comments I have installed Apache php & MySql I ...
4
votes
4answers
10k 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 ...
8
votes
7answers
31k 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 ...
3
votes
2answers
20k views

The phpMyAdmin configuration storage is not completely configured

I typed apt-get install phpmyadmin and ran into an error saying it cannot connect to mysql (socket issue). It was normal because I forget to install mysql before, so I selected "abort" above all ...
1
vote
1answer
3k views

Install ODBC connector for PostgreSQL on Ubuntu Server 12.04

I try to install the ODBC driver for PostgreSQL on Ubuntu Server 12.04. The purpose is to connect R (which is also running on the Server)to the database. I somehow got stock because I did not find a ...
0
votes
0answers
15 views

remove mysql with its unmet dependencies from ubuntu

I tried to install mysql into ubuntu The installation file was .deb It was not properly installed. Now i want to remove it. I used following command to remove it sudo apt-get remove --purge ...
3
votes
5answers
2k views

After upgrading to 12.04 from 10.04, can't login to PHPMYADMIN

I just can't login to PhpMyAdmin anymore, it says bad logins. PHP works perfectly. Please help. Thank you. 2002 Cannot log in to the MySQL server Language Log in Username: Password: Connection for ...
1
vote
1answer
37 views

MySql 5.6 crashing on Ubuntu 15.04 arm64

I installed mysql using the command sudo apt-get install mysql-server At the end of the installation it throws error saying "Unable to set Root password". I tried googling and reading other ...
0
votes
1answer
22 views

How can I stop another working webserver?

I get this error when I try to start Apache web server. I've been working on it for about a month and suddenly this error appeared today: error:: xampp: another webserver is already running. any ...
3
votes
2answers
9k views

Shell script issue: cron job script to Restart MySQL server when it stops accidentally

I have this script, I am using it to setup CRON job to execute this script, so it can check if MySQL service is running; if not then it restart the MySQL service: #!/bin/bash service mysql status| ...
0
votes
1answer
3k views

“'Access denied for user 'root'@'localhost'” when trying to do commands

The other day I was using MySQL on my local database fine from the terminal. However, when I rebooted the next day and tried to use it, I get the following error for just about EVERYTHING related to ...
0
votes
0answers
30 views

Can someone please explain this mysql statement to me [migrated]

I am trying to learn mysql on my own by debugging a php program. However I am now stuck. I do not understand what this particular statement is or what it does: $StatusRequirements = array( ...
0
votes
1answer
4k views

Turn off MySQL --skip-grant -tables

I reset my root mysql password with the following instructions: (Works for Ubuntu as well) http://www.debian-administration.org/articles/442 But now I can't turn off mysqld_safe --skip-grant-tables. ...
0
votes
0answers
18 views

how to access mysql in console

I installed mysql alone with xampp and runing all services successfully, but when i try to login to mysql server using mysql-client it gives the following error. user@user-pc:~$ sudo /opt/lampp/lampp ...
0
votes
0answers
11 views

Why use Amazon's AWS RDS instance for mysql instead of just manually creating mysql?

I was playing around with Amazon AWS and at this point just not sure what are the benefits of creating an RDS instance for lets say mysql database instead of simply login in into the server and ...
2
votes
6answers
14k views

Upstart can't start MySQL

After an installation of MySQL, I get a few errors and I can't run the MySQL daemon. I've tried uninstalling and reinstalling several times, and I'm not sure what's going on. Here's a snippit of what ...
1
vote
3answers
46 views

Mysql didn't startup after rebooting

After I rebooted my server, everything started up normally except for "mysql", i tried to start it up manually "/etc/init.d/mysql restart" or with "service mysql restart", it fails In log file it ...
0
votes
0answers
45 views

Keystone Identity service: Unable to establish connection

Can someone please help. I've been stuck on this for quite some time now and its frustrating me alot. I cant move forward. keystone tenant-create --name admin --description "Admin Tenant" Unable to ...
6
votes
7answers
21k views

dpkg: invoke-rc.d: initscript mysql, action “start” failed

I have read a number of the posts here and they all state to run the following commands: Apt-get -f remove ** apt-get update apt-get upgrade apt-get -f install ** I have seen these in various ...
1
vote
2answers
6k 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 ...
1
vote
1answer
48 views

Wrong permissions on configuration file of phpmyadmin

I have installed xampp on Ubuntu 15.04 and after starting the server, I get: phpMyAdmin - Error Wrong permissions on configuration file, should not be world writable! How should I proceed?
0
votes
0answers
22 views

NGINX Auth support and MYSQL

I have installed NGINX server. The requirement is to allow only certain IP addresses to access this service. The list of allowed IP are stored in a MYSQL database. I was able to install and configure ...
0
votes
0answers
27 views

MySQL remote access doesn't work when there isn't internet connection in router

I'm using Ubuntu Server 14.04, and installed MySQL 5.6 to be accessed remotely on my LAN. Everything is working perfectly, except when I lose my router internet connection. My ISP goes down often, so ...