Re: Access denied for MySQL user in Django

Hi, as far as i understood cdraccess is a DB gust user, right? If so, from your DB admin user, grant cdraccess to access MySQL environment table 'mysql.user' as follow: GRANT SELECT ON `mysql`.`user` TO 'user_gui'@'%'; To me it worked, Ivan On Monday, January 25, 2016 at 7:52:33 PM UTC+1,

Re: Access denied for MySQL user in Django

Hi, as far as i understood cdraccess is a DB gust user, right? If so, from your DB admin user, grant cdraccess to access MySQL environment table 'mysql.user' as follow: GRANT SELECT ON `mysql`.`user` TO 'cdraccess'@'%'; To me it worked, Ivan On Thursday, January 14, 2016 at 2:27:27 PM

Re: Access denied for MySQL user in Django

> > >> And I get the usual error message: >> >> (1045, u"Access denied for user 'cdraccess'@'77.95.177.35' (using password: >> NO)") >> >> >> I have print statements and everything looks correct. It is printed as it >> is in the settings.py file. >> >> One thing I noticed is that the IP

Re: Access denied for MySQL user in Django

On Mon, Jan 25, 2016 at 8:19 AM, Galil wrote: > I changed my settings.py file like this: > > 'cdraccess': { > 'ENGINE': 'django.db.backends.mysql', > 'NAME': 'portal2', > 'USER': 'cdraccess', > 'HOST': '127.0.0.1', > 'CONN_MAX_AGE':

Re: Access denied for MySQL user in Django

I changed my settings.py file like this: 'cdraccess': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'portal2', 'USER': 'cdraccess', 'HOST': '127.0.0.1', 'CONN_MAX_AGE': 0, 'PASSWORD': 'mydbpass', }, And the error message I get is:

Re: Access denied for MySQL user in Django

On Fri, Jan 22, 2016 at 7:06 AM, Galil wrote: > That was helpful James, we are nearly there. > > You were right the output was "DB Password:", with an empty string. I > added my password as default value like: > > 'PASSWORD': os.environ.get('CDR_DB_PASSWORD',

Re: Access denied for MySQL user in Django

That was helpful James, we are nearly there. You were right the output was "DB Password:", with an empty string. I added my password as default value like: 'PASSWORD': os.environ.get('CDR_DB_PASSWORD', 'my_password_here'), but there is something really strange happening. When I use

Re: Access denied for MySQL user in Django

On Thu, Jan 14, 2016 at 4:11 AM, Galil wrote: > I have created a Django app and which uses MySQL. The settings.py file in > the database sections is: > > DATABASES = { > 'cdraccess': { > 'ENGINE': 'django.db.backends.mysql', > 'NAME':

Re: Access denied for MySQL user in Django

Galil, Try this also: mysql> use mysql; mysql> delete from user where host='%' and 'user=''; mysql> flush privileges; --Fred Fred Stluka -- mailto:f...@bristle.com -- http://bristle.com/~fred/ Bristle Software, Inc --

Re: Access denied for MySQL user in Django

Using password no. Have you set notempty password with creating table permission? 15 січ. 2016 18:20 "Galil" пише: > Hi Fred, > > The user cdraccess is not the root user and it does not have the rights to > access table 'user'. I deleted the guest user as root but nothing

Re: Access denied for MySQL user in Django

Hi Fred, The user cdraccess is not the root user and it does not have the rights to access table 'user'. I deleted the guest user as root but nothing changes. The problem was not fixed. On Thursday, 14 January 2016 17:50:21 UTC, Fred Stluka wrote: > > Galil, > > I had a problem like this a

Re: Access denied for MySQL user in Django

Galil, I had a problem like this a couple years ago, and the solution was to delete the anonymous MySQL guest user as: mysql> use mysql; mysql> delete from user where host='localhost' and 'user=''; mysql> flush privileges; I'm not sure why Django 1.4 was trying to connect as the guest user

Access denied for MySQL user in Django

I have created a Django app and which uses MySQL. The settings.py file in the database sections is: DATABASES = { 'cdraccess': { 'ENGINE': 'django.db.backends.mysql', 'NAME': os.environ.get('CDR_DB_NAME', 'portal2'), 'USER': os.environ.get('CDR_DB_USER',