Mysql .. Access Denied

49 views
Skip to first unread message

mhe...@vieracom.com

unread,
Jul 18, 2013, 8:17:24 AM7/18/13
to erpnext-dev...@googlegroups.com
Hi,

I am a new in erpnext and when make the installation I got an exception, as below :

Cloning erpnext
.
.
Cloning wnframework
.
.
Traceback (most recent call last):
  File "install_erpnext.py", line 333, in <module>
    install()
  File "install_erpnext.py", line 14, in install
    install_erpnext(install_path)
  File "install_erpnext.py", line 171, in install_erpnext
    setup_db(install_path, root_password, db_name)
  File "install_erpnext.py", line 231, in setup_db
    inst.import_from_db(db_name, verbose=1)
  File "lib/webnotes/install_lib/install.py", line 55, in import_from_db
    self.dbman.delete_user(target)
  File "lib/webnotes/model/db_schema.py", line 337, in delete_user
    raise e
_mysql_exceptions.OperationalError: (1227, 'Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation')


Regards.

Anand Doshi

unread,
Jul 18, 2013, 8:39:54 AM7/18/13
to erpnext-dev...@googlegroups.com
You need to have mysql root user privileges for installation.

During install, system will ask you for root user password.

This root user should have CREATE USER privilege. If root user doesn't have it, something is wrong with your mysql setup.

-Anand.

--
Note:
 
If you are posting an issue,
1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
 
End of Note
---
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

mhe...@vieracom.com

unread,
Jul 18, 2013, 8:48:32 AM7/18/13
to erpnext-dev...@googlegroups.com
Thanks Anand

But I test Mysql Server and I see that 'root' user have all privileges

Should I repeat the installation process of Mysql ?

or there is another solution ?

Thanks again :)

Anand Doshi

unread,
Jul 18, 2013, 8:52:34 AM7/18/13
to erpnext-dev...@googlegroups.com
Are you using mysql server as a service? 

Mohamed Helmy

unread,
Jul 21, 2013, 9:33:19 AM7/21/13
to erpnext-dev...@googlegroups.com
yes, Iam using mysql as a service
and I can not install erpnext 
any suggestions ?


You received this message because you are subscribed to a topic in the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-developer-forum/Nt6p_THRMG4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to erpnext-developer...@googlegroups.com.

Rushabh Mehta

unread,
Jul 22, 2013, 2:29:12 AM7/22/13
to erpnext-dev...@googlegroups.com
Hi,

Please have a look at this file:


The way the install works is that it creates a user and database (of the same name) using "root" and then creates all the initial tables from the model (txt) files (for which you do not need root).

In your case, you may have to create the database manually and then use install to only create the tables.

best,
Rushabh


Twitter: @rushabh_mehta

Mohamed Helmy

unread,
Jul 24, 2013, 8:03:08 AM7/24/13
to erpnext-dev...@googlegroups.com
Thanks for help, Rushabh.
Reply all
Reply to author
Forward
0 new messages