I put a password in that last comment like a complete idiot. Well, I've
changed it, and if you try to follow along you'll want to substitute
't1g3r' in the above grant command to whatever you want your root mysql
password to be.
--
You received this bug notification because you are a member of U
I got it fixed, thanks to post #4 on this thread:
http://ubuntuforums.org/showthread.php?t=1836919
Start your mysql client as shown below:
mysql -u debian-sys-maint -p
In another terminal, 'cat' the file /etc/mysql/debian.cnf (you'll have
to 'sudo cat' it). That file contains a password; pas
Clint, is there a way to fix this for those of us in this unpleasant
situation?
--
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.1 in Ubuntu.
https://bugs.launchpad.net/bugs/542543
Title:
Access denied for user 'root'@'lo
In looking at this closer, I believe this is a bug in the debian-start
script.
Because pipes mask errors in the left-most commands (only the last
command in pipes have errors detected), we're not detecting the problem
with the mysql upgrade process, leading to the error you see in comment
#10.
De
We are undergoing a big change in the mysql 5.1 packages for lucid right
now due to the undisclosed security problems released by Oracle. Can
somebody affected please try this after upgrading to the 5.1.61 packages
that are in lucid-proposed?
Thanks!
--
You received this bug notification because
I have a very similar problem. I'm running Ubuntu 10.04 LTS with mysql 5.1.
I have not created any users other than the defaults.
Server version: 5.1.41-3ubuntu12.1 (Ubuntu)
I can do this:
mysql
mysql> create database foobar;
I can't do this:
mysql> grant create temporary tables on *.* to public;
no, thats not the problem
ls -lah /var/lib/mysql/
insgesamt 157M
drwx-- 41 mysql mysql 4,0K 2010-04-19 17:38 .
drwxr-xr-x 63 root root 4,0K 2010-04-19 17:10 ..
drwx-- 2 mysql mysql 4,0K 2010-03-20 09:19 alientxcsql1
drwx-- 2 mysql mysql 4,0K 2010-03-13 10:59 alientxcsql2
drwx--
** Changed in: mysql-dfsg-5.1 (Ubuntu)
Status: Incomplete => Invalid
--
Access denied for user 'root'@'localhost' to database SOMEDB
https://bugs.launchpad.net/bugs/542543
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5
The /var/lib/mysql directory is suppose to have mysql:mysql permissions
so thats probably what your problem is.
--
Access denied for user 'root'@'localhost' to database SOMEDB
https://bugs.launchpad.net/bugs/542543
You received this bug notification because you are a member of Ubuntu
Server Team,
root has all privileges. I can also give the pack the complete
/var/lib/mysql/ folder and give them to somebodys mail adress. But dont
like it, because of sensive data.
I currently install a up to date package and try again
--
Access denied for user 'root'@'localhost' to database SOMEDB
https://
We'd like to figure out what's causing this bug for you, but we haven't
heard back from you in a while. Could you please provide the requested
information? Thanks!
--
Access denied for user 'root'@'localhost' to database SOMEDB
https://bugs.launchpad.net/bugs/542543
You received this bug notifica
I'm not able to reproduce your problem on a fresh lucid install:
$ mysql -u root -pmypwd
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 40
Server version: 5.1.41-3ubuntu9 (Ubuntu)
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
mysql.log and mysql.err is empty
--
Access denied for user 'root'@'localhost' to database SOMEDB
https://bugs.launchpad.net/bugs/542543
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu.
--
Ubuntu-server-bugs maili
I restarted mysql damon und repeat the steps i have written ... but
thats all what is in daemon.log
Mar 24 01:17:20 s01 /etc/mysql/debian-start[31437]: Upgrading MySQL tables if
necessary.
Mar 24 01:17:20 s01 /etc/mysql/debian-start[31440]: /usr/bin/mysql_upgrade: the
'--basedir' option is alway
Can you attach your /var/log/daemon.log, please?
Thanks
chuck
** Changed in: mysql-dfsg-5.1 (Ubuntu)
Importance: Undecided => Medium
** Changed in: mysql-dfsg-5.1 (Ubuntu)
Status: New => Incomplete
--
Access denied for user 'root'@'localhost' to database SOMEDB
https://bugs.launchpad
** Description changed:
When I try to give my user xy rights to database xy I receive the access
denied message:
mysql> CREATE USER 'testdb1'@'localhost' IDENTIFIED BY 'testpw';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT USAGE ON * . * TO 'testdb1'@'localhost' IDENTIFIED BY
** Attachment added: ".etc.apparmor.d.usr.sbin.mysqld.txt"
http://launchpadlibrarian.net/41392878/.etc.apparmor.d.usr.sbin.mysqld.txt
** Attachment added: "Dependencies.txt"
http://launchpadlibrarian.net/41392879/Dependencies.txt
** Attachment added: "MySQLConf.etc.mysql.my.cnf.txt"
htt
17 matches
Mail list logo
