One user 2+ database
One user 2+ database
how to let one mysql user have 2+ database? or create db user themselves?
userA > db1 + db2 + ....
userA > db1 + db2 + ....
Re: One user 2+ database
With phpmyadmin .
In other database use privileges to add rights your user..
In other database use privileges to add rights your user..
Re: One user 2+ database
hi skurudo~skurudo wrote:With phpmyadmin .
In other database use privileges to add rights your user..
after adding privileges, FTP is not connecting.
after I add a db in CP, phpmyadmin show one user has two hosts, which are % and Localhost, is it normal?
after I restart server in CP, mysql is connecting failed. but it shows started in CP, I gotta restart mysql, thing works normal.
Re: One user 2+ database
It's very odd, what's in logs?after adding privileges, FTP is not connecting.
Why? What's in logs?after I restart server in CP, mysql is connecting failed.
...what's parameters your vps/server?
Re: One user 2+ database
AWS ubuntu 14, where can i found logs?skurudo wrote:It's very odd, what's in logs?after adding privileges, FTP is not connecting.
Why? What's in logs?after I restart server in CP, mysql is connecting failed.
...what's parameters your vps/server?
Re: One user 2+ database
[quote="skurudo"]/var/log
/usr/local/vesta/log
https://vestacp.com/docs/#config-log-lo ... ian-ubuntu[/quote
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
150328 19:47:34 InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
150328 19:47:34 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/ ... codes.html
150328 19:47:34 InnoDB: Could not open or create data files.
150328 19:47:34 InnoDB: If you tried to add new data files, and it failed here,
150328 19:47:34 InnoDB: you should now edit innodb_data_file_path in my.cnf back
150328 19:47:34 InnoDB: to what it was, and remove the new ibdata files InnoDB created
150328 19:47:34 InnoDB: in this failed attempt. InnoDB only wrote those files full of
150328 19:47:34 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
150328 19:47:34 InnoDB: remove old data files which contain your precious data!
150328 19:47:34 [ERROR] Plugin 'InnoDB' init function returned error.
150328 19:47:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150328 19:47:34 [ERROR] Unknown/unsupported storage engine: InnoDB
150328 19:47:34 [ERROR] Aborting
150328 19:47:34 [Note] /usr/sbin/mysqld: Shutdown complete
150328 19:47:34 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150328 20:10:39 [Note] /usr/sbin/mysqld: Normal shutdown
150328 20:10:39 [Note] Event Scheduler: Purging the queue. 0 events
150328 20:10:39 InnoDB: Starting shutdown...
150328 20:10:41 InnoDB: Shutdown completed; log sequence number 1676453
150328 20:10:41 [Note] /usr/sbin/mysqld: Shutdown complete
150328 20:10:45 [Note] Plugin 'FEDERATED' is disabled.
150328 20:10:45 InnoDB: The InnoDB memory heap is disabled
150328 20:10:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150328 20:10:45 InnoDB: Compressed tables use zlib 1.2.8
150328 20:10:45 InnoDB: Using Linux native AIO
150328 20:10:45 InnoDB: Initializing buffer pool, size = 128.0M
150328 20:10:45 InnoDB: Completed initialization of buffer pool
150328 20:10:45 InnoDB: highest supported file format is Barracuda.
150328 20:10:45 InnoDB: Waiting for the background threads to start
150328 20:10:46 InnoDB: 5.5.41 started; log sequence number 1676453
150328 20:10:46 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150328 20:10:46 [Note] - '0.0.0.0' resolves to '0.0.0.0';
150328 20:10:46 [Note] Server socket created on IP: '0.0.0.0'.
150328 20:10:46 [Note] Event Scheduler: Loaded 0 events
150328 20:10:46 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
150328 20:16:52 [Note] /usr/sbin/mysqld: Normal shutdown
150328 20:16:52 [Note] Event Scheduler: Purging the queue. 0 events
150328 20:16:52 InnoDB: Starting shutdown...
150328 20:16:53 InnoDB: Shutdown completed; log sequence number 1676453
150328 20:16:53 [Note] /usr/sbin/mysqld: Shutdown complete
150328 20:17:21 [Note] Plugin 'FEDERATED' is disabled.
150328 20:17:21 InnoDB: The InnoDB memory heap is disabled
150328 20:17:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150328 20:17:21 InnoDB: Compressed tables use zlib 1.2.8
150328 20:17:21 InnoDB: Using Linux native AIO
150328 20:17:21 InnoDB: Initializing buffer pool, size = 128.0M
150328 20:17:21 InnoDB: Completed initialization of buffer pool
150328 20:17:21 InnoDB: highest supported file format is Barracuda.
150328 20:17:21 InnoDB: Waiting for the background threads to start
150328 20:17:22 InnoDB: 5.5.41 started; log sequence number 1676453
150328 20:17:22 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150328 20:17:22 [Note] - '0.0.0.0' resolves to '0.0.0.0';
150328 20:17:22 [Note] Server socket created on IP: '0.0.0.0'.
150328 20:17:22 [Note] Event Scheduler: Loaded 0 events
150328 20:17:22 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
/usr/local/vesta/log
https://vestacp.com/docs/#config-log-lo ... ian-ubuntu[/quote
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
150328 19:47:34 InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
150328 19:47:34 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/ ... codes.html
150328 19:47:34 InnoDB: Could not open or create data files.
150328 19:47:34 InnoDB: If you tried to add new data files, and it failed here,
150328 19:47:34 InnoDB: you should now edit innodb_data_file_path in my.cnf back
150328 19:47:34 InnoDB: to what it was, and remove the new ibdata files InnoDB created
150328 19:47:34 InnoDB: in this failed attempt. InnoDB only wrote those files full of
150328 19:47:34 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
150328 19:47:34 InnoDB: remove old data files which contain your precious data!
150328 19:47:34 [ERROR] Plugin 'InnoDB' init function returned error.
150328 19:47:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150328 19:47:34 [ERROR] Unknown/unsupported storage engine: InnoDB
150328 19:47:34 [ERROR] Aborting
150328 19:47:34 [Note] /usr/sbin/mysqld: Shutdown complete
150328 19:47:34 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150328 20:10:39 [Note] /usr/sbin/mysqld: Normal shutdown
150328 20:10:39 [Note] Event Scheduler: Purging the queue. 0 events
150328 20:10:39 InnoDB: Starting shutdown...
150328 20:10:41 InnoDB: Shutdown completed; log sequence number 1676453
150328 20:10:41 [Note] /usr/sbin/mysqld: Shutdown complete
150328 20:10:45 [Note] Plugin 'FEDERATED' is disabled.
150328 20:10:45 InnoDB: The InnoDB memory heap is disabled
150328 20:10:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150328 20:10:45 InnoDB: Compressed tables use zlib 1.2.8
150328 20:10:45 InnoDB: Using Linux native AIO
150328 20:10:45 InnoDB: Initializing buffer pool, size = 128.0M
150328 20:10:45 InnoDB: Completed initialization of buffer pool
150328 20:10:45 InnoDB: highest supported file format is Barracuda.
150328 20:10:45 InnoDB: Waiting for the background threads to start
150328 20:10:46 InnoDB: 5.5.41 started; log sequence number 1676453
150328 20:10:46 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150328 20:10:46 [Note] - '0.0.0.0' resolves to '0.0.0.0';
150328 20:10:46 [Note] Server socket created on IP: '0.0.0.0'.
150328 20:10:46 [Note] Event Scheduler: Loaded 0 events
150328 20:10:46 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
150328 20:16:52 [Note] /usr/sbin/mysqld: Normal shutdown
150328 20:16:52 [Note] Event Scheduler: Purging the queue. 0 events
150328 20:16:52 InnoDB: Starting shutdown...
150328 20:16:53 InnoDB: Shutdown completed; log sequence number 1676453
150328 20:16:53 [Note] /usr/sbin/mysqld: Shutdown complete
150328 20:17:21 [Note] Plugin 'FEDERATED' is disabled.
150328 20:17:21 InnoDB: The InnoDB memory heap is disabled
150328 20:17:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150328 20:17:21 InnoDB: Compressed tables use zlib 1.2.8
150328 20:17:21 InnoDB: Using Linux native AIO
150328 20:17:21 InnoDB: Initializing buffer pool, size = 128.0M
150328 20:17:21 InnoDB: Completed initialization of buffer pool
150328 20:17:21 InnoDB: highest supported file format is Barracuda.
150328 20:17:21 InnoDB: Waiting for the background threads to start
150328 20:17:22 InnoDB: 5.5.41 started; log sequence number 1676453
150328 20:17:22 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150328 20:17:22 [Note] - '0.0.0.0' resolves to '0.0.0.0';
150328 20:17:22 [Note] Server socket created on IP: '0.0.0.0'.
150328 20:17:22 [Note] Event Scheduler: Loaded 0 events
150328 20:17:22 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
Re: One user 2+ database
User Host Password Global privileges Grant Action
admin_testing % Yes USAGE No Edit Privileges Edit Privileges Export Export
admin_testing localhost Yes USAGE No Edit Privileges Edit Privileges Export Export
after adding user in CP. there two user in phpmyadmin. is it normal? which one I might make right to privileges to?
the % one or the localhost one?
admin_testing % Yes USAGE No Edit Privileges Edit Privileges Export Export
admin_testing localhost Yes USAGE No Edit Privileges Edit Privileges Export Export
after adding user in CP. there two user in phpmyadmin. is it normal? which one I might make right to privileges to?
the % one or the localhost one?
Re: One user 2+ database
From logs I can see two problems
1) ibdata1 - this may be apc or mysql try to start twice - viewtopic.php?f=14&t=6861&p=20746&hilit ... ice#p20746
2) need to tune your config for cpu/memory usage of your server
1) ibdata1 - this may be apc or mysql try to start twice - viewtopic.php?f=14&t=6861&p=20746&hilit ... ice#p20746
2) need to tune your config for cpu/memory usage of your server
Re: One user 2+ database
This topic wll help you:inertown wrote:after adding user in CP. there two user in phpmyadmin. is it normal? which one I might make right to privileges to?
http://serverfault.com/questions/565343 ... phpmyadmin