Questions regarding the MySQL database server, client and tools.
2
votes
0answers
41 views
upgrade MySQL through apt not effect?
I am upgrading mysql-server and mysql-client my 12.04 using apt-get.
seems the upgrade didn't take effect?
Any thoughts why this happen? I did reboot after upgrade. Thanks.
$ mysql -V
mysql Ver ...
2
votes
0answers
777 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 ...
2
votes
0answers
95 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 ...
2
votes
0answers
656 views
Enabling SSL in MySQL
I'm running Ubuntu Server 12.04, and I want to enable SSL connections to MySQL.
I've generated the following keys/certs files with OpenSSL:
ca-cert.pem
server-cert.pem
server-key.pem
I stored ...
1
vote
0answers
13 views
Mysql5.6 and problem of php5-mysql , mysql-common packages
I install Mysql 5.6 with this documentaion(in ubuntu 13.04) , now I need to install php5-mysql and mysql-common packages. can I install them with apt-get? I think they will install mysql5.5 ...
1
vote
0answers
97 views
Problem while deploying MysQL through Juju in LXC
I'm trying to follow the Juju tutorial do deploy MySQL and Wordpress, but I found a problem in MySQL deploy process.
The error appears right after mysql-server installation, when the service is ...
1
vote
0answers
164 views
Access denied for user 'tt-rss'@'localhost' after installing tt-rss
Just installed Tiny Tiny RSS. Accessing http://localhost/tt-rss from the browser brings me the following error:
Unable to connect to database (as tt-rss to , database ttrss): Access
denied for ...
1
vote
0answers
102 views
How I can connect the syslog-ng with a mysql database?
Hi guys I want to use a syslog-ng server for logging data from the firewall and I get Data from the Firewall in the file /var/firewall.log but now I want that the logs go to a database. For this I ...
1
vote
0answers
32 views
Error: Mysql database doesn't support transactions
I have a InnoDB has a default database which supports transactions. But, when I run transactions script for Mysql sql-benchmarking I get below error:
Show engines:
...
1
vote
0answers
57 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 ...
1
vote
0answers
183 views
Ubuntu 12.04 failed mysql installation
I have deployed Ubuntu 12.04 on the Amazon Cloud and I am trying to install Nagios and Nconf, while following this guide. When I install the prerequisites, I get this error on installing mysql:
...
1
vote
0answers
97 views
How to install threadsafe version of MySQLdb for python in Ubuntu 12.04?
Ubuntu 12.04 , 64 bit version.
mysql-client,mysql-server,libmysqlclient-dev all are installed.
But libmysqlclient_r.so was not present in this path :
...
1
vote
0answers
25 views
Mysql gives syntax error
When I try to access mysql I get this:
$ sudo mysql -h localhost -u webmaster
[sudo] password for webmaster:
/usr/local/bin/mysql: 1: /usr/local/bin/mysql: Syntax error: "(" unexpected
I used the ...
1
vote
0answers
116 views
public address null and present state pending after destroy-environment , disabling firewall and bootstrap again
I have done everystep as it was written on ubuntu 12.04 maas, but now i am stuck here for over a month and could not find how to solve it .. Please help ..
When i do juju status it says :
...
1
vote
0answers
119 views
MySQL Workbench Only Loading When Using Sudo
First and foremost I cannot load the .deb file directly from MYSQL (version 5.2.42), it loads the software manager and gives me a not found error.
The version I can find in the software manager is ...
1
vote
0answers
341 views
PHP MYAdmin with MySQL Cluster Server
I am trying to install PHPMyAdmin onto an ubuntu 11.04 server running MySQL Cluster-server
It keeps failing with the following error:
php5-mysql : Depends: libmysqlclient16 (>= 5.1.21-1) but it is ...
1
vote
0answers
56 views
Showing tables without database name in LibreOffice
I have set up a connection with MySQL connector in LibreOffice (Ubuntu 12.04) and now I see the database tables like:
dbname
table1
table2
In earlier versions of LibreOffice one ...
1
vote
0answers
890 views
MySQL Workbench will not open on my Ubuntu 12.04
I have install mysql-workbench version 5.2.38+dfsg-3
via Ubuntu Software Center on my Ubuntu 12.04 laptop for some week ago,
This work fine until now!
Now when I press in the mysql-workbench icon ...
0
votes
0answers
15 views
apt-hell broken dependancies for mysql server
'devillj@bbj-EP45-UD3R:/var/log/mysql$ sudo apt-get install -f
Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting ...
0
votes
0answers
12 views
How do I connect mysql from weka?
I am trying to connect to MYSQL running WEKA using the following
# JDBC driver (comma-separated list)
jdbcDriver=com.mysql.jdbc.Driver
# database URL
jdbcURL=jdbc:mysql://localhost:3306/test
My ...
0
votes
0answers
11 views
upgrade percona-server package fails
This has been happening for a few weeks. Every other package upgrades without issue except this one, but I'm not sure what's causing this or how to debug it.
sudo apt-get upgrade
Reading package ...
0
votes
0answers
16 views
Connecting to mysql 5.5
I'm trying to manage MySQL 5.5 but in Terminal I get the following Warning after entering the password:
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: ...
0
votes
0answers
8 views
Using gnome-keyring with svn via ssh and mysql-workbench
Problem: mysql-workbench fails to connect to the keyring to connect to mysql.
I'm trying to get my svn command (which uses an svn+ssh uri) to prompt me to enter my password for my local rsa secrets. ...
0
votes
0answers
13 views
xampp could not be start?
I installed XAMPP for Linux a couple of days ago and was working fine. Today I do wrongly
chmod 777 /opt/lampp
then MySQL won't be started. then I completely uninstall XAMPP then again install ...
0
votes
0answers
40 views
Why wouldn't MySQL install correctly?
I am newbie to ubuntu. While I was trying to install MySQL, I got the following errors, and need some help trying to understand how to fix the problem.
Setting up mysql-server-5.5 ...
0
votes
0answers
31 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
0answers
96 views
Install Navicat on Linux Ubuntu 12.04
How do I install Navicat on Ubuntu Desktop 12.04?
I have just configured a new Ubuntu 12.04. Because I'm not so familiar with the command line, I prefer to use Ubuntu Desktop so that I can have a ...
0
votes
0answers
21 views
Reinstalling Mysql On Ubuntu 10.10(Stuck with bad repositories)
I recently configured NDB-cluster with mysql and Mysql just crashed ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
tried re-installing ...
0
votes
0answers
66 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
0answers
24 views
I can't open mysql
I can't be able to open my mysql query browser. I just started to work with xampp and php. So i just installed my xampp in to my local machine. Now I have a problem in opening mysql query browser. ...
0
votes
0answers
66 views
mysql-server installation problem
I am having trouble installing mysql-server.
I have done
> sudo apt-get install mysql-server
I get prompted to set a root password. Whether I opt to set one or not is fails and I get the ...
0
votes
0answers
44 views
MyISAM problem after moving datadir of a MySQL database
I recently moved my MySQL database data directory from the default location /var/lib/mysql onto a new harddrive located in /media/..UID../mysql, following the steps you can find in several posts.
...
0
votes
0answers
54 views
Error 2003 Mysql
I have mysql-server in Virtualbox (Ubuntu server 12.10). Its 192.168.1.5
CREATE USER 'user-db'@'localhost' IDENTIFIED BY 'pass';
GRANT ALL PRIVILEGES ON db.* TO 'user-web'@'localhost'
-> WITH ...
0
votes
0answers
11 views
php script kills rest of the page when it is included
ok, i work with php and, i created file that collects all of data from database for user with the $_SESSION['email'] but,
when i try to represent data for that user,
it works in that file, also if ...
0
votes
0answers
22 views
Cron ran but early
I have a cronjob to run at 3.15 to backup database but the file was saved at 2.15?
here is the line in /etc/crontab
15 3 * * * root bash /home/user/backup.sh
And the bash file
#!/bin/sh
...
0
votes
0answers
15 views
I Want to Program jdbc in ubuntu with MySql
I want to Practise Jdbc Programs with Mysql in Ubuntu 12.04
So If you can Help me in Installing Procedure and Running up the Program it would be nice
0
votes
0answers
78 views
Instalation of MySql Cluster problem - Can't change dir (Errcode: 13)
I want to install MySql Cluster on my Ubuntu 12.04(64bit).
I am using MySQL Cluster Quick Start Guide – LINUX for instructions.
I have changed ownership of $HOME/my_cluster and $HOME/mysqlc to mysql ...
0
votes
0answers
44 views
Can not install phpmyadmin and mysql
after an interrupted upgrade of ubuntu 10.04 server LTS to ubuntu 12.04 server LTS somethings weren't installed correctly. Anyways I installed apache, ftp, phpmyadmin etc. At some point I deleted some ...
0
votes
0answers
62 views
NDOUtils installation unable to load data into Mysql database
I have installed nagios server and its Working fine. later i thought of integrating the same with mysql Database via NDOUtils, But when i start the nod2db I m getting an error message in nagios ...
0
votes
0answers
1k views
Install MySQL 5.6 on Ubuntu 12.10
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
0answers
602 views
The phpMyAdmin configuration storage is not completely configured
Question : was the below procedure the right things to do ?
On Ubuntu server 12.04, fresh install :
I typed apt-get install phpmyadmin and ran into an error saying it cannot connect to mysql (socket ...
0
votes
0answers
70 views
connecting to mysql running on amazon ec2
hi I am trying to connect mysql server running on amazon linux instance but did not succeeded yet .
Scenario : i installed mysql server in amazon's ec2 instance . then I made following changes in ...
0
votes
0answers
97 views
Nginx + Drizzle + Mysql + PHP
Trying to connect nGinX with Drizzle to upstream mysql "drizzle_server" in config file of nGinX. But every time i install it it has "unknown directive"
I tried:
...
0
votes
0answers
86 views
How can I bypass tasksel asking me for a mysql-server password when installing lamp-server?
I'm trying to install LAMP with a script, without user interaction. What I'm doing:
sudo apt-get install -y tasksel
sudo tasksel install lamp-server
Tasksel then asks me to set a root mysql server ...
0
votes
0answers
26 views
How to create a relationship and one-to-many in mysql Server
How to create a relationship and one-to-many in MySQL
0
votes
0answers
28 views
Problem with MySQL installation
I followed this tutorial for installing it: https://help.ubuntu.com/community/ApacheMySQLPHP
Apache is working fine but somehow mysql is missing something...
When I do:
sudo service mysql status
...
0
votes
0answers
44 views
How to alter mysql table using trigger
How to alter mysql table before insert rows using trigger.
If not possible with trigger any way to do that same?
0
votes
0answers
293 views
Can't install mysql-server
I've been trying for a day or two now to apt-get install mysql-server.
I ran into this error below during my first installation (and it also fails to set the mysql root password if I choose to enter ...
0
votes
0answers
16 views
in MySQL Workbench where there was a complement to the code
In MySQL Workbench where there was a complement to the code we write in the program, but now in the new version this property does not exist
0
votes
0answers
173 views
Ubuntu 12.10 MySQL slow connection
After update to 12.10 I have problem with very slow connection only with MySQL which are in Virtual Machine. In every query it delay 10 seconds.
If somebody had and solved same problem. I'll ...
