0
votes
2answers
27 views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I know that some users may say that this is a duplication but seriously I have combed the answers and those on the internet for over half a day and I am so frustrated i am going to explode. Now that ...
0
votes
0answers
34 views

Ubuntu 12.04 problems with mysql

I use Ubuntu Server 12.04 for my Django project. On my local PC there is no errors and etc. Sometimes on server I have error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
-2
votes
0answers
17 views

Help on mail server on Ubuntu 12.04

I'm having problems on getting start a mail server on Ubuntu 12.04. I just try this tutorial for Debian Wheezy, but without sucess... I really need a mail server running with: Postfix, Dovecot, ...
1
vote
0answers
21 views

Subdirectories Show 404 Not Found on 13.10 web server

I recently set up a web server on Ubuntu 13.10 and when I enter the external IP it works fine showing the index file of var/www/ but whenever I try to add a folder, say one called test, and I go to ...
3
votes
1answer
21 views

How to transfer MySQL database from Windows to Ubuntu?

I want to transfer my database from WAMP on my local machine to my Ubuntu VPS. Can I just copy the folder of the database from C:\wamp\bin\mysql\mysql5.6.12\data to /var/lib/mysql?
0
votes
0answers
21 views

MySQLdb on Brython?

Hi there I'm working on a server-based point of sale for a sports club, and downloaded Mysqldb lib so that I can access and modify it through python scripts, they work great!, so I decided to use ...
0
votes
0answers
156 views

Mysql cannot start when upgrade 5.5 to 5.6

I following this link to upgrade my mysql, https://rtcamp.com/tutorials/mysql/mysql-5-6-ubuntu-12-04/ The article ubuntu is x64, But my ubuntu is x32, So I change the download link to ...
2
votes
0answers
17 views

SSL is not in use on MySQL server [duplicate]

I installed MySQL server and I want to allow SSL support. I added these lines to my.cnf [client] ssl-ca=/etc/mysql/ca-cert.pem ssl-cert=/etc/mysql/client-cert.pem ssl-key=/etc/mysql/client-key.pem ...
0
votes
1answer
45 views

No reaction on service mysql start, init script works

After upgrading Ubuntu from 12.04 to 13.10, the MySQL server (now 5.5) does not start/stop with service mysql start|stop. When typing /etc/init.d/mysql start, everything works fine. Once it does ...
0
votes
0answers
43 views

Setting Max Connections in MySQL server Globally [duplicate]

I installed my UBUNTU 12.04.4 LTS X64 yesterday and didn't installed anything except mysql-server and mysql-client. But htop showing 20 mysqld identical processes. *--Process----- MEM%---VIRT --- ...
0
votes
2answers
177 views

MySQL Access denied for user 'root'@'localhost'

In my server, everytime I try to access MySQL I get the error: Access denied for user 'root'@'localhost' (using password: NO) when I try mysqladmin -u root -p password I get Access ...
0
votes
1answer
63 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
36 views

Mysql died and won't start

I am working on Ubuntu 12.10 server with nginx, mysql and unicorn installed. There is something wrong with Mysql and has stopped working. Log message from /var/log/mysql/error.log Attempting ...
0
votes
0answers
61 views

trying to understand libapache2-mod-auth-mysql

I'm trying to install mysql server, client and phpmyadmin. I was able to successfully install mysql server and the client.. on the phpmyadmin, from the video instruction i was trying to follow it says ...
0
votes
0answers
34 views

How do I configure mysqld to allow ssh tunnel connections

I'm looking to find out how to configure mysqld to accept socket connections from an SSH tunnel. This is what I am currently doing: Create the tunnel: $ ssh -N -L 8033:localhost:3306 sqlserver ...
0
votes
1answer
45 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
1answer
64 views

mysql server in ubuntu 13.04 not showing databases

i have installed Xampp(LAMPP) in Ubuntu 13.04 . i have secured the xampp phpmyadmin Mysql FTP. status showing ACTIVATED.now, i have installed mysql server.in terminal write mysql -u root -p and then ...
0
votes
1answer
42 views

php and mysql issues

I've recently read Wallace Wang's “Beginning Programming for Dummies, 7 books in 1” and found it to be very enlightening, as it highlighted various differences between the three main operating systems ...
0
votes
2answers
485 views

accessing MySQL using terminal in Ubuntu 13.04

accessing phpmyadmin db from terminal now in ubuntu 13.04 i firstly installed mysql server with sudo apt-get install mysql-server mysql server version 5.5 now in terminal i can check if it is working ...
0
votes
1answer
175 views

Can't Connect to MySQL via CLI or phpMyAdmin, but WordPress still connects fine

This is the first time I've had to reach out for a question -- I'm truly stumped. I have mysql up and running on a linux server (Ubuntu) and this morning tried to login to phpMyAdmin. I received an ...
1
vote
2answers
169 views

Ubuntu 13.10 apache keeps giving this error while accessing website

I have just installed Ubuntu 13.10. I followed this guide (most of it) to setup LAMP. Then I was getting this error about Could not reliably determine the server's fully qualified domain name ...
0
votes
1answer
350 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
47 views

VSFTPD Allowing A User To Edit Any File

I finally got VSFTPD working with PAM and MySQL, and I want to know how I can have an FTP user that makes editing the server easily. Essentially what I want is for my ftp user to be able to have the ...
0
votes
2answers
6k views

ERROR 1045(28000) : Access denied for user 'root@localhost' (using password: no )

I got a problem with mysql server Actually i am not sure im tring to install queXS cati app on my ubuntu desktop i installed mysql server and php5 and when im trying mysql -u root it says "ERROR ...
2
votes
0answers
84 views

Ubuntu virtual memory overcommit apparently hitting MySql performance

I have several installations using Ubuntu Server 10.04 and 12.04 LTS running on Dedicated and VPS with various hosting companies. I am hitting a problem where, especially on migrating to a new server ...
0
votes
0answers
131 views

MySQL - upgrade or new installation?

I am running MySQL 5.5.32 on an Ubuntu-Server 12.04.3 LTS. I want to have the newest version of MySQL on my Machine, which at the moment seems to be 5.7.3. All instructions I have seen say, that I ...
0
votes
0answers
89 views

How to manage sqlite database with ubuntu server 12.04

I have installed php and sqlite in my Ubuntu server running nginx. I'm in doubt in how I should manage the SQL database. How should I install something like phpmyadmin that would work in these ...
0
votes
3answers
455 views

The best LAMP Stack with a GUI for Web Dev

I'm a spoilt windows user and always have used a WAMP stack with a GUI that allows me to start or stop apache and mysql services. I find it really hard switching to the LAMP command line and was ...
0
votes
1answer
309 views

Is there any way to get a MySQL database from a /var backup?

I upgraded from Ubuntu 12.10 to Ubuntu 13.10. After some time, I found that I didn't export all my MySQL databases. Some of them are missing. I still have a backup from my /var/ partition, but I ...
0
votes
1answer
209 views

Wordpress permissions problem on apache2 server

I have a windows 7 system. On this system i am running a VM Virtual box LAMP Server with Ubuntu 12.04,apache2, mysql and phpmyadmin... which is accessable via the internet. I installed Wordpress ...
0
votes
1answer
386 views

Can't Install php5-msql

Hello friends I'm finishing the process of installing Apache/Php/mysql installations but this shows up: # sudo apt-get install mysql-server php5-msql Reading package lists... Done Building ...
0
votes
2answers
68 views

Ubuntu server and services

I've been using Linux+Plesk Virtual Server as a web server for a while, but I want to give a try on doing it manually, so my question is: I'll have a server which is: 80GB HDD, 4GB RAM, 1TB Bandwith, ...
0
votes
1answer
234 views

127.0.0.1:9051 doesnt work after apache, mysql, php installation?

I have installed apache2, mysql, and php and now it doesn't let Vidalia run on localhost. I tried to change the TCP connection (controlport) to any other ip 192.168.0.40 and tried to change the ...
0
votes
2answers
452 views

OpenVZ Ubuntu 13.04 VPS - unable to install MySQL

Today I bought a VPS from edis.at, OVZ Starter, and I installed Ubuntu 13.04 x64 on it. On a fresh install, running apt-get install mysql-server, freezes apt-get. After setting the MySQL root ...
1
vote
2answers
815 views

/tmp directory: 0 files but shows full?

Related to another post where I was finally able to delete files within /tmp thanks to another poster. However, in the end the sysadmin had to restore a snapshot of a few days ago to get the mysql ...
0
votes
0answers
34 views

Ubuntu Server setup package

I would like to ask about setting up my own server with Ubuntu, at the moment I am paying for hosting on a VPS running Ubuntu which I pay £50 per month for starters which as the site grows it will go ...
0
votes
1answer
571 views

ubuntu 12.04 lts secure lamp server

So ... i've been been unfortunate with my linux VPS server running 12.04.3 lts. I had a bad php script running that basically opened up for a mysql injection. And because of a stupid configuration ...
0
votes
0answers
147 views

Apache: Restrict Web Page Access To Windows Domain Users

I have a Ubuntu Server 12.04 running on a VPS and it has a web server on it running the latest version of apache, MySQL and PHP. How can I restrict access to my server so only people trying to ...
1
vote
0answers
211 views

installing Percona XtraDB Cluster on Ubuntu 13.04

So, a bit of explanation of the big picture: I am trying to get multiple PXC instances running on a single machine, replicating via Galera to each other. I am running Ubuntu Server 13.04 amd64 in a ...
0
votes
0answers
597 views

Mysql processes with high CPU usage

Mysql server is consuming very high values (80-120%) every few seconds (once every 5-10 sec), is that usual? Mysql processlist is not big at all, I don't use to see more than 3 queries simultaneously. ...
1
vote
1answer
52 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
50 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'; ...
0
votes
1answer
476 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
262 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? / ...
2
votes
2answers
4k 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 ...
2
votes
2answers
3k 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] ...
0
votes
2answers
97 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 ...
1
vote
3answers
392 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
0answers
34 views

php and mysql programming not working

I'm having a weird problem. I wrote a 2 line php(mysql connect) and some html..but..when I run the page..it just shows a blank page. Here's the code : - <?php $db = mysql_connect('127.0.1.1', ...
0
votes
1answer
752 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 ...