Mysql .. Access Denied

[mhe...@vieracom.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]

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]

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]

Are you using mysql server as a service? 

[Mohamed Helmy]

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]

Hi,

Please have a look at this file:

https://github.com/webnotes/wnframework/blob/master/webnotes/install_lib/install.py

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

https://erpnext.com

Twitter: @rushabh_mehta

[Mohamed Helmy]

Thanks for help, Rushabh.