2回答

sqlercn

2020-07-22

这个错误是密码错误，你可以在server.xml中先使用非加密的密码试一下看是不是可以登录，如果可以登录则可能是密码加密的问题。

0

0

qq_醉生梦死_16

提问者

2020-07-22

schema代码：<?xml version="1.0"?>

<!DOCTYPE mycat:schema SYSTEM "schema.dtd">

<mycat:schema xmlns:mycat="http://io.mycat/">

     <schema name="imooc_db" checkSQLschema="false" sqlMaxLimit="100">

    <table dataNode="ordb" name="order_master" primaryKey="order_id"/>

<table dataNode="ordb" name="order_detail" primaryKey="order_detail_id"/>

<table dataNode="ordb" name="order_cart" primaryKey="cart_id"/>

<table dataNode="ordb" name="order_customer_addr" primaryKey="customer_addr_id"/>

<table dataNode="ordb" name="region_info" primaryKey="region_id"/>

<table dataNode="ordb" name="shipping_info" primaryKey="ship_id"/>

<table dataNode="ordb" name="warehouse_info" primaryKey="w_id"/>

<table dataNode="ordb" name="warehouse_proudct" primaryKey="wp_id"/>

<!--<table dataNode="prodb" name="product_brand_infos" primaryKey="brand_id"/>-->

<!--<table dataNode="prodb" name="product_category" primaryKey="category_id"/>-->

<!--<table dataNode="prodb" name="product_comment" primaryKey="comment_id"/>-->

<!--<table dataNode="prodb" name="product_info" primaryKey="product_id"/>-->

<!--<table dataNode="prodb" name="product_supplier_info" primaryKey="supplier_id"/>-->

<!--<table dataNode="prodb" name="product_pic_info" primaryKey="product_pic_id"/>-->

<!--<table dataNode="custdb" name="customer_balance_log" primaryKey="balance_id"/>-->

<!--<table dataNode="custdb" name="customer_inf" primaryKey="customer_inf_id"/>-->

<!--<table dataNode="custdb" name="customer_level_inf" primaryKey="customer_level"/>-->

<!--<table dataNode="custdb" name="customer_login" primaryKey="customer_id"/>-->

<!--<table dataNode="custdb" name="customer_login_log" primaryKey="login_id"/>-->

<!--<table dataNode="custdb" name="customer_point_log" primaryKey="point_id"/>-->

</schema>

     <dataNode name="ordb" dataHost="mysql8314" database="order_db">

     <!--<dataNode name="prodb" dataHost="mysql8315" database="product_db">-->

     <!--<dataNode name="custdb" dataHost="mysql8316" database="customer_db">-->

<dataHost name="mysql8314" slaveThreshold="100" switchType="1" dbDriver="native" dbType="mysql" writeType="0" balance="1" minCon="10" maxCon="1000">

<heartbeat>select user()</heartbeat>

<writeHost password="123456" user="im_mycat" url="125.65.83.14:3306" host="125.65.83.14"/>

</dataHost>    

    <!--<dataHost name="mysql8315" maxCon="1000" minCon="10" balance="3" writeType="0"-->

     <!--   dbtype="mysql" dbDriver="native" switchtype="1">-->

     <!--   <heartbeat> select user() </hearbeat>-->

     <!--   <writeHost host="122.114.83.15" url="122.114.83.15:3306" user="im_mycat" password="123456" />-->

     <!--</dataHost>-->

     <!--<dataHost name="mysql8316" maxCon="1000" minCon="10" balance="3" writeType="0"-->

     <!--   dbtype="mysql" dbDriver="native" switchtype="1">-->

     <!--   <heartbeat> select user() </hearbeat>-->

     <!--   <writeHost host="122.114.83.16" url="122.114.83.16:3306" user="im_mycat" password="123456" />-->

     <!--</dataHost>-->

</mycat:schema>

server代码：

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mycat:server SYSTEM "server.dtd">

<mycat:server xmlns:mycat="http://io.mycat/">

<system>

<property name="serverPort">8066</property>

<property name="managerPort">9066</property>

<property name="nonePasswordLogin">0</property> <!-- 0为需要密码登陆、1为不需要密码登陆 ,默认为0，设置为1则需要指定默认账户-->

<property name="bindIp">0.0.0.0</property>

<property name="frontWriteQueueSize">2048</property>

<property name="charset">utf8</property>

    <property name="txIsolation">2</property>

    <property name="processors">8</property>

    <property name="idleTimeout">1800000</property>

    <property name="sqlExecuteTimeout">300</property>

    <property name="useSqlStat">0</property>

    <property name="useGlobleTableCheck">0</property>

    <property name="sequnceHandlerType">2</property>

    <property name="defaultMaxLimit">100</property>

    <property name="maxPacketSize">104857600</property>

    

</system>

<user name="app_imooc" defaultAccount="true">

<property name="usingDecrypt">1</property>

<property name="password">bDbWr7bVMgszTe82oMo8NaUsmFFdPCNl/lYXzOYoG8anTpQLvdx5e+LYJEmT0IAeSVp1loyxSZPyv1GoHbHFHg==</property>

<property name="schemas">imooc_db</property>

    </user>

    

<!--<user name="root" defaultAccount="true">-->

<!-- <property name="usingDecrypt">1</property>-->

<!-- <property name="password">jAPiFvZ7Oet75uw6GjyWuNiT5dFJhQjdJ862viU/LzaLhRrexXn8bvQZEULdsk6k5/xIb8opq0bTvCAWS39veg==</property>-->

<!-- <property name="schemas">TESTDB</property>-->

<!-- <property name="defaultSchema">TESTDB</property>-->

<!--No MyCAT Database selected 错误前会尝试使用该schema作为schema，不设置则为null,报错 -->

<!-- 表级 DML 权限设置 -->

<!--

<privileges check="false">

<schema name="TESTDB" dml="0110" >

<table name="tb01" dml="0000"></table>

<table name="tb02" dml="1111"></table>

</schema>

</privileges>

-->

<!--</user>-->

</mycat:server>

0

0