Mysql command is deprecated. Did you mean "bench mariadb after using bench mariadb also i am not getting

[kittusai]

Can any one help me how to resolve this.this is getting after starting the bench.after using bench mariadb i am getting like this insted of opening database

after using bench mariadb i am getting like this insted of opening database

Thanks & Regards
sai krishna

[rohit_w]

Hi @kittusai
Bench mariadb is same as bench mysql, you can run the mysql query

[kittusai]

yeah bro, I got it bro but i didn’t know how to close this incident.

[rohit_w]

Try “exit”

[kittusai]

yeah i came to know that exit command bro tq very much

[kittusai]

the problem what i am facing here is it is not showing all the tables in a single instance when i click on enter i going in step by step tables…

[hetal1110]

When using command “bench mariadb”, following error is shown,

frappe@ubuntu:~/frappe-bench$ bench mariadb
Traceback (most recent call last):
File “/usr/lib/python3.5/runpy.py”, line 184, in _run_module_as_main
“main”, mod_spec)
File “/usr/lib/python3.5/runpy.py”, line 85, in _run_code
exec(code, run_globals)
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, lin e 97, in
main()
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, lin e 18, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py” , line 722, in call
return self.main(*args, **kwargs)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py” , line 697, in main
rv = self.invoke(ctx)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py” , line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py” , line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py” , line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py” , line 535, in invoke
return callback(*args, **kwargs)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/decorato rs.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/init.py”, line 25, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/utils.py”, line 32 1, in mariadb
os.execv(mysql, args)
PermissionError: [Errno 13] Permission denied

Please help!

Thanks!

[kennethsequeira]

try bench --site sitename mariadb

[hetal1110]

Showing the same error…, as posted above

+++++++++++
frappe@ubuntu:~/frappe-bench$ bench --site library mariadb
Traceback (most recent call last):
File “/usr/lib/python3.5/runpy.py”, line 184, in _run_module_as_main
“main”, mod_spec)
File “/usr/lib/python3.5/runpy.py”, line 85, in _run_code
exec(code, run_globals)
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, lin e 97, in
main()
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, lin e 18, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py” , line 722, in call
return self.main(*args, **kwargs)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py” , line 697, in main
rv = self.invoke(ctx)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py” , line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py” , line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py” , line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/core.py” , line 535, in invoke
return callback(*args, **kwargs)
File “/home/frappe/frappe-bench/env/lib/python3.5/site-packages/click/decorato rs.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/init.py”, line 25, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/utils.py”, line 32 1, in mariadb
os.execv(mysql, args)
PermissionError: [Errno 13] Permission denied

[hetal1110]

Any other suggestions??

How do I Connect mysql?

[rohit_w]

Try

mysql -u db_name -p db_name

To check db_name and password, open the site_config.json file under your site folder

[hetal1110]

Thanks!

But while doing so, got Access denied.
Please find attached

Thanks!

[rohit_w]

Why user name and db name are different in your mysql command?
Can you share the output of site_config.json file

[hetal1110]

Done…Thanks!

[hetal1110]

Can not make changes in .py file

Just added below line in .py file
def validate(self):

And got below error, PFA

Any help please?