科技改变生活-雨落星辰 - 所有的伟大,都源于一个勇敢的开始

    最新消息：雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客
    你的位置： 首页>programmer>woocommerce offtopic - Is it safe to have 2 mysql users?

    woocommerce offtopic - Is it safe to have 2 mysql users?

    programmeradmin0浏览0评论

    we have a WooCommerce website and it has a single database. In wp-config.php I setup the connection to the database:

    user1
name_of_db
psw_for_db_user

    We have an ERP software installed on our office and we bought a software that will synchronize some data between ERP and WooCommerce (orders, prices, stock…).

    This software (in the middle between the ERP and WC) needs to connect directly to the database of WordPress. Can I create a new user and password to connect to the database from this software? Is it safe or we will ecounter problems in WordPress/WooCommerce having two different db users making changes in the db?

    Thanks!

    we have a WooCommerce website and it has a single database. In wp-config.php I setup the connection to the database:

    user1
name_of_db
psw_for_db_user

    We have an ERP software installed on our office and we bought a software that will synchronize some data between ERP and WooCommerce (orders, prices, stock…).

    This software (in the middle between the ERP and WC) needs to connect directly to the database of WordPress. Can I create a new user and password to connect to the database from this software? Is it safe or we will ecounter problems in WordPress/WooCommerce having two different db users making changes in the db?

    Thanks!

    • woocommerce-offtopic
    • database
    Share Improve this question asked Feb 5, 2021 at 12:12 morris4ever69morris4ever69 1
    Add a comment  | 

    1 Answer 1

    Reset to default 2

    Can I create a new user and password to connect to the database

    Yes, this is perfectly fine. Usually applications like WordPress or WooCommerce do not care about what user they are using for the connection - as long as they can read and write data as they need to.

    You might even consider it good practice to have different db users for different applications. So if ever your WP got hacked, they would not have the credentials for the other application / database.

    Is it safe or we will ecounter problems in WordPress/WooCommerce having two different db users making changes in the db?

    This can be problematic. If the other application deletes a product from the Woo db, the product is gone. So if you give another application access to the DB that WordPress is using, you need to be aware that this software could potentially destroy your WP instance.

    This is usually where trust comes in. Is that ERP coming from a known vendor that has good reviews, and does their official guide say that it is good to connect directly to the Woo database? Then it should be fine.

    与本文相关的文章

    发布评论

    评论列表(0)

    1. 暂无评论
    ok 不同模板 switch ($forum['model']) { /*case '0': include _include(APP_PATH . 'view/htm/read.htm'); break;*/ default: include _include(theme_load('read', $fid)); break; } } break; case '10': // 主题外链 / thread external link http_location(htmlspecialchars_decode(trim($thread['description']))); break; case '11': // 单页 / single page $attachlist = array(); $imagelist = array(); $thread['filelist'] = array(); $threadlist = NULL; $thread['files'] > 0 and list($attachlist, $imagelist, $thread['filelist']) = well_attach_find_by_tid($tid); $data = data_read_cache($tid); empty($data) and message(-1, lang('data_malformation')); $tidlist = $forum['threads'] ? page_find_by_fid($fid, $page, $pagesize) : NULL; if ($tidlist) { $tidarr = arrlist_values($tidlist, 'tid'); $threadlist = well_thread_find($tidarr, $pagesize); // 按之前tidlist排序 $threadlist = array2_sort_key($threadlist, $tidlist, 'tid'); } $allowpost = forum_access_user($fid, $gid, 'allowpost'); $allowupdate = forum_access_mod($fid, $gid, 'allowupdate'); $allowdelete = forum_access_mod($fid, $gid, 'allowdelete'); $access = array('allowpost' => $allowpost, 'allowupdate' => $allowupdate, 'allowdelete' => $allowdelete); $header['title'] = $thread['subject']; $header['mobile_link'] = $thread['url']; $header['keywords'] = $thread['keyword'] ? $thread['keyword'] : $thread['subject']; $header['description'] = $thread['description'] ? $thread['description'] : $thread['brief']; $_SESSION['fid'] = $fid; if ($ajax) { empty($conf['api_on']) and message(0, lang('closed')); $apilist['header'] = $header; $apilist['extra'] = $extra; $apilist['access'] = $access; $apilist['thread'] = well_thread_safe_info($thread); $apilist['thread_data'] = $data; $apilist['forum'] = $forum; $apilist['imagelist'] = $imagelist; $apilist['filelist'] = $thread['filelist']; $apilist['threadlist'] = $threadlist; message(0, $apilist); } else { include _include(theme_load('single_page', $fid)); } break; default: message(-1, lang('data_malformation')); break; } ?>