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
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;
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
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.
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
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;
** 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
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
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
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
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
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
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
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
** 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
** 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
16 matches
Mail list logo