for mysql :
create database test;
grant all on test.* to test@'localhost' identified by 'test';
grant all on test.* to test@'%' identified by 'test';
to run scripts in mysql
mysql> source <path to sql file>
MySql export schema without data
mysqldump -u root -p --no-data dbname > schema.sql
MySql DB commands
Related Posts:
Hadoop ? What is Hadoop? Hadoop is a free, Java-based programming framework that supports the processing of large data sets in a distributed computing environment. It is part of the Apache project sponsored by the Apache Software Fo… Read More
java.lang.classnotfoundexception org.springframework.web.context.contextloaderlistener / ClassNotFoundException when running a Spring + Maven2 project on Tomcat from within Eclipse I had a similar problem when running a spring web application in an Eclipse managed tomcat. I solved this problem by adding maven dependencies in the project's web deployment assembly. 1) Open the project's properties (e.g.… Read More
Spring REST web service Test We can test the Spring REST web service by following : 1. By java Junit class. 2. By SoapUI. 3. By Firefox browser plugin REST CLIENT. 4. By Chrome browser plugin POST MAN. 1. By java Junit class : We can write the j… Read More
WARN (DefaultHandlerExceptionResolver.java:183) - Request method 'POST' not supported. For Spring REST When Spring RESTful web service post call are throwing following exception, then we need to check 'Content-type' is set in the header/request. set the content-type in the testing client like SoapUI. if the REST controll… Read More
MySql DB commandsfor mysql : create database test; grant all on test.* to test@'localhost' identified by 'test'; grant all on test.* to test@'%' identified by 'test'; to run scripts in mysql mysql> source <path to sql file> MySql… Read More
0 comments:
Post a Comment