5

[ubuntu] Ubuntu 12.04 MySQL User

view full story
linux-howto

http://ubuntuforums.org – Hi, I'm looking for a bit of help creating an Ubuntu user account (not a MySQL user account) to remotely administer MySQL from MySQL Workbench. Workbench uses SSH to initiate admin commands and the setup wizard specifies that: This account needs write access to the my.cnf database config file, read access to the database logs and privileges to start/stop the database daemon. I'm currently running the MySQL Ubuntu box as a VM, so i've enabled the root account for this purpose and that's working fine. However, I want to move MySQL to a more potentially vulnerable location and would l (Hardware)

linuxfan's picture
Submitted by linuxfan on 08/16/2012 – Made popular on 08/16/2012

Stories similar to [ubuntu] Ubuntu 12.04 MySQL User

I'm on Windows 7 with MySQL Workbench 5.2.44 CE trying to connect to MySQL database at a remote Ubuntu 12.04.1 server using "Standard TCP/IP over SSH" feature of MySQL Workbench with a passphrased SSH key.

MySql - mysql-workbench problem 2 years 43 weeks ago

Hi Guys,

I am looking to use the mysql tool mysql-workbench to administer mysql.

I downloaded the latest version from the MySql website, the fedora rpm. I used rpm2tgz to create a slackware package. Install seemed to go okay.

When I tried to run the mysql-workbench tool I got the following message.

I've just installed MySQL workbench on my computer and have importend an old database into the system which seems to be working find. All the data is there and tables. I can do select, insert, updates etc.

However, if I expand a database, I see tables, views, routines. If I then right click on tables, nothing happens if I click create table...

I am getting dependency package errors as .

root@osscube:/home/abdul/Downloads# dpkg -i mysql-workbench-gpl-5.2.47-1ubu1004-amd64.deb Selecting previously unselected package mysql-workbench-gpl. (Reading database ...

I have configured my MySQL Database to require passwords on all users, even root from the machine itself.

Now I discovered that there are empty Users in my Database

Reproduce: mysql -u root -p and then use mysql; & select * from user;

it gives me 2 entries, one with "localhost" and user and one with the machine's hostname and .

now i tried to access the account with mysql -u ' ' (yes it's

We've got a Virtual Server with full ssh and root access running LAMP on Ubuntu Server.

I've got a small computer in the office running ubuntu that isn't being used for anything. I thought I should use it to make and store (a copy of) our MySQL database backups.

I've written a custom wrapper script around /script/pkgacct which will

Separately process mysql database backups (including user database yaml file + mysql database schema itself) from the web files in /home/username and use parallel compression in form of pigz.This also allows me to to switch mysql backup methods from mysqldump to multi-threaded mysql backup tool, mydumper (mydumper confirmed t

MySQL Workbech Wont Connect 2 years 43 weeks ago

I installed on my local desk workstation the MySQL Workbench application. It installed perfect and when I try to create a new connection to my database, it fails and tells me:

Quote:

Failed to Connect to MySQL at 192.168.0.79:3306 with user cmennens

I'm running MySQL 5.5.20 on OS X 10.6.8. Using MySQL Administrator 1.2.12 (the latest) I am unable to edit any accounts. After successfully connecting to the database in MySQL Administrator, I go the Account tab, expand a user, and it just says "Loading...".