Who is familiar with MySQL? Help me!# Biology - 生物学
m*g
1 楼
在ustraveldocs上注册时，护照填错了，以为数字1是字母I，签证费也交了。现在在网
站上反馈让他们帮忙修改，但是不知道他们需要多久，也不知道签证费是否需要重交。
有类似经验的人说说吧，非常感谢。
站上反馈让他们帮忙修改，但是不知道他们需要多久，也不知道签证费是否需要重交。
有类似经验的人说说吧，非常感谢。
A*8
2 楼
韩国最近的娱乐圈特别热闹，从金贤重到现在的朴有天，闹的满城风雨，可想而知这两
个人的演艺生涯估计也就到头了。
夜店F4就有金贤重、朴有天、金在中、TOP，已经有两个人出事儿了，要是这另外的两
个人出事估计就不是几个人的事情了吧，怎么也得有好多人。现在TOP那么红也快去当
兵了，赶脚够呛呀。
艺人的私生活太乱，真是不知道什么时候就背后来一枪，有那句老话叫你约的炮跪着也
要打完，就没有不透风的墙，还是在娱乐圈，这肯定是不注意就要死的。
个人的演艺生涯估计也就到头了。
夜店F4就有金贤重、朴有天、金在中、TOP，已经有两个人出事儿了，要是这另外的两
个人出事估计就不是几个人的事情了吧，怎么也得有好多人。现在TOP那么红也快去当
兵了，赶脚够呛呀。
艺人的私生活太乱，真是不知道什么时候就背后来一枪，有那句老话叫你约的炮跪着也
要打完，就没有不透风的墙，还是在娱乐圈，这肯定是不注意就要死的。
s*2
3 楼
I am using a software which must interact with MySQL database. I have
installed this software (named stacks) and MySQL. There are two command when
I use this software:
~/directory mysql -e "CRAETA DATABASE 1"
~/directory 1 < /usr/local/share/stacks/sql/stacks.sql
I am a very new to linux system and MySQL. I know the first command is going
to create a database in MySQL named 1. The manual of the software explains
the second command as "send the database table definitions to the server to
create all the necessary components of the database ". When I run the first
command under MySQL, it is ok. But it will show "Error 1064: you have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near "1 < /usr/local/share/stacks
/sql/stacks.sql" at line1" when I run the second command.
I am wondering whether someone know what's the actual meaning of the second
command. I am totally confused.
PS: the software I used is "Stacks" and installed in the default path "/usr/
local/share/stacks".
Thanks, everyone! I am in the lab and can't type in Chinese. Sorry.
installed this software (named stacks) and MySQL. There are two command when
I use this software:
~/directory mysql -e "CRAETA DATABASE 1"
~/directory 1 < /usr/local/share/stacks/sql/stacks.sql
I am a very new to linux system and MySQL. I know the first command is going
to create a database in MySQL named 1. The manual of the software explains
the second command as "send the database table definitions to the server to
create all the necessary components of the database ". When I run the first
command under MySQL, it is ok. But it will show "Error 1064: you have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near "1 < /usr/local/share/stacks
/sql/stacks.sql" at line1" when I run the second command.
I am wondering whether someone know what's the actual meaning of the second
command. I am totally confused.
PS: the software I used is "Stacks" and installed in the default path "/usr/
local/share/stacks".
Thanks, everyone! I am in the lab and can't type in Chinese. Sorry.
m*g
4 楼
收到网站回复，“您的申请个案已更新，请重新登录账户查看详情”。
可是登录网站一看，护照号码还是不对的。
【在 m**********g 的大作中提到】
: 在ustraveldocs上注册时，护照填错了，以为数字1是字母I，签证费也交了。现在在网
: 站上反馈让他们帮忙修改，但是不知道他们需要多久，也不知道签证费是否需要重交。
: 有类似经验的人说说吧，非常感谢。
可是登录网站一看，护照号码还是不对的。
【在 m**********g 的大作中提到】
: 在ustraveldocs上注册时，护照填错了，以为数字1是字母I，签证费也交了。现在在网
: 站上反馈让他们帮忙修改，但是不知道他们需要多久，也不知道签证费是否需要重交。
: 有类似经验的人说说吧，非常感谢。
P*l
5 楼
打开那个stacks.sql文件看看语法哪错了啊？
m*g
6 楼
再次提供反馈，并附上护照页的扫描版之后，他们更新了护照号码。
反应还是比较快的，赞一个。
不过，我在反馈中询问是否需要重新去中信交费，他们没有回应，我想，应该是不需要
吧。
【在 m**********g 的大作中提到】
: 收到网站回复，“您的申请个案已更新，请重新登录账户查看详情”。
: 可是登录网站一看，护照号码还是不对的。
反应还是比较快的，赞一个。
不过，我在反馈中询问是否需要重新去中信交费，他们没有回应，我想，应该是不需要
吧。
【在 m**********g 的大作中提到】
: 收到网站回复，“您的申请个案已更新，请重新登录账户查看详情”。
: 可是登录网站一看，护照号码还是不对的。
s*8
7 楼
the 2nd command is about creating tables in your database 1.
if you are not familiar with linux, you can download and install MySQL
Workbench on windows and log to your mysql server on linux. Then execute "
stacks.sql" in MySQL Workbench.
when
going
explains
to
first
【在 s********2 的大作中提到】
: I am using a software which must interact with MySQL database. I have
: installed this software (named stacks) and MySQL. There are two command when
: I use this software:
: ~/directory mysql -e "CRAETA DATABASE 1"
: ~/directory 1 < /usr/local/share/stacks/sql/stacks.sql
: I am a very new to linux system and MySQL. I know the first command is going
: to create a database in MySQL named 1. The manual of the software explains
: the second command as "send the database table definitions to the server to
: create all the necessary components of the database ". When I run the first
: command under MySQL, it is ok. But it will show "Error 1064: you have an
if you are not familiar with linux, you can download and install MySQL
Workbench on windows and log to your mysql server on linux. Then execute "
stacks.sql" in MySQL Workbench.
when
going
explains
to
first
【在 s********2 的大作中提到】
: I am using a software which must interact with MySQL database. I have
: installed this software (named stacks) and MySQL. There are two command when
: I use this software:
: ~/directory mysql -e "CRAETA DATABASE 1"
: ~/directory 1 < /usr/local/share/stacks/sql/stacks.sql
: I am a very new to linux system and MySQL. I know the first command is going
: to create a database in MySQL named 1. The manual of the software explains
: the second command as "send the database table definitions to the server to
: create all the necessary components of the database ". When I run the first
: command under MySQL, it is ok. But it will show "Error 1064: you have an
I*y
8 楼
install a MySQL management UI software such as phpmyadmin on your server,
and then import the .sql file through the user interface, and it can track
down what error (if any) it throws to you.
the second command line is an attempt to import the mysql dump file. However, I think the command
line is wrong, though I'm not sure what Linux distro you are using. If you are on the kernel prompt (e.g.
ssh), use this command:
mysql -u username -p database_name < /path/to/the/mysql/dump/directory/dumpfile.sql
this command line assumes that your mysql server is your localhost.
make sure the mysql username above has privilege to write to the database_name, or just use the root user.
When you import the file, make sure it's an intact mysql dump, meaning you don't open it and
save it. If you have opened it and saved it, some lines in the dump file
may have been altered, throwing errors like this Error 1064.
when
going
explains
to
first
【在 s********2 的大作中提到】
: I am using a software which must interact with MySQL database. I have
: installed this software (named stacks) and MySQL. There are two command when
: I use this software:
: ~/directory mysql -e "CRAETA DATABASE 1"
: ~/directory 1 < /usr/local/share/stacks/sql/stacks.sql
: I am a very new to linux system and MySQL. I know the first command is going
: to create a database in MySQL named 1. The manual of the software explains
: the second command as "send the database table definitions to the server to
: create all the necessary components of the database ". When I run the first
: command under MySQL, it is ok. But it will show "Error 1064: you have an
and then import the .sql file through the user interface, and it can track
down what error (if any) it throws to you.
the second command line is an attempt to import the mysql dump file. However, I think the command
line is wrong, though I'm not sure what Linux distro you are using. If you are on the kernel prompt (e.g.
ssh), use this command:
mysql -u username -p database_name < /path/to/the/mysql/dump/directory/dumpfile.sql
this command line assumes that your mysql server is your localhost.
make sure the mysql username above has privilege to write to the database_name, or just use the root user.
When you import the file, make sure it's an intact mysql dump, meaning you don't open it and
save it. If you have opened it and saved it, some lines in the dump file
may have been altered, throwing errors like this Error 1064.
when
going
explains
to
first
【在 s********2 的大作中提到】
: I am using a software which must interact with MySQL database. I have
: installed this software (named stacks) and MySQL. There are two command when
: I use this software:
: ~/directory mysql -e "CRAETA DATABASE 1"
: ~/directory 1 < /usr/local/share/stacks/sql/stacks.sql
: I am a very new to linux system and MySQL. I know the first command is going
: to create a database in MySQL named 1. The manual of the software explains
: the second command as "send the database table definitions to the server to
: create all the necessary components of the database ". When I run the first
: command under MySQL, it is ok. But it will show "Error 1064: you have an
L*d
9 楼
stacks.sql这个文件里的某一个（些）statement有语法错误
打开那个文件看看
when
going
explains
to
first
【在 s********2 的大作中提到】
: I am using a software which must interact with MySQL database. I have
: installed this software (named stacks) and MySQL. There are two command when
: I use this software:
: ~/directory mysql -e "CRAETA DATABASE 1"
: ~/directory 1 < /usr/local/share/stacks/sql/stacks.sql
: I am a very new to linux system and MySQL. I know the first command is going
: to create a database in MySQL named 1. The manual of the software explains
: the second command as "send the database table definitions to the server to
: create all the necessary components of the database ". When I run the first
: command under MySQL, it is ok. But it will show "Error 1064: you have an
打开那个文件看看
when
going
explains
to
first
【在 s********2 的大作中提到】
: I am using a software which must interact with MySQL database. I have
: installed this software (named stacks) and MySQL. There are two command when
: I use this software:
: ~/directory mysql -e "CRAETA DATABASE 1"
: ~/directory 1 < /usr/local/share/stacks/sql/stacks.sql
: I am a very new to linux system and MySQL. I know the first command is going
: to create a database in MySQL named 1. The manual of the software explains
: the second command as "send the database table definitions to the server to
: create all the necessary components of the database ". When I run the first
: command under MySQL, it is ok. But it will show "Error 1064: you have an
s*2
10 楼
谢谢提醒，我对这个真是太不熟悉了，结果我打开那个stacks.sql一看，是空白的。呜
呜。我也不知道是不是我安装软件的时候出现问题了。
【在 P**l 的大作中提到】
: 打开那个stacks.sql文件看看语法哪错了啊？
呜。我也不知道是不是我安装软件的时候出现问题了。
【在 P**l 的大作中提到】
: 打开那个stacks.sql文件看看语法哪错了啊？
s*2
11 楼
Thanks, IVYtony! I am using Ubuntu 11.04. I changed the stacks.sql, and
shouldn't have a problem with it any more. But when I run the second command
, the error show up "error 1045 (28000): Access denied for user 'root'@'
localhost' (using password : No)" . I googled the error. Most suggested
resetting the password. But if I run "mysql -u root -p" and enter my
password. I can get into the mysql. I am totally don't know how to do
troubleshooting. I have been working on this for almost one week, starting
installing the linux system, the software, and MySQL. I feel so frustrated.
:( Any other suggestion would be greatly appreciated.
However, I think the command
are on the kernel prompt (e.g.
dumpfile.sql
name, or just use the root user.
don't open it and
【在 I*****y 的大作中提到】
: install a MySQL management UI software such as phpmyadmin on your server,
: and then import the .sql file through the user interface, and it can track
: down what error (if any) it throws to you.
: the second command line is an attempt to import the mysql dump file. However, I think the command
: line is wrong, though I'm not sure what Linux distro you are using. If you are on the kernel prompt (e.g.
: ssh), use this command:
: mysql -u username -p database_name < /path/to/the/mysql/dump/directory/dumpfile.sql
: this command line assumes that your mysql server is your localhost.
: make sure the mysql username above has privilege to write to the database_name, or just use the root user.
: When you import the file, make sure it's an intact mysql dump, meaning you don't open it and
shouldn't have a problem with it any more. But when I run the second command
, the error show up "error 1045 (28000): Access denied for user 'root'@'
localhost' (using password : No)" . I googled the error. Most suggested
resetting the password. But if I run "mysql -u root -p" and enter my
password. I can get into the mysql. I am totally don't know how to do
troubleshooting. I have been working on this for almost one week, starting
installing the linux system, the software, and MySQL. I feel so frustrated.
:( Any other suggestion would be greatly appreciated.
However, I think the command
are on the kernel prompt (e.g.
dumpfile.sql
name, or just use the root user.
don't open it and
【在 I*****y 的大作中提到】
: install a MySQL management UI software such as phpmyadmin on your server,
: and then import the .sql file through the user interface, and it can track
: down what error (if any) it throws to you.
: the second command line is an attempt to import the mysql dump file. However, I think the command
: line is wrong, though I'm not sure what Linux distro you are using. If you are on the kernel prompt (e.g.
: ssh), use this command:
: mysql -u username -p database_name < /path/to/the/mysql/dump/directory/dumpfile.sql
: this command line assumes that your mysql server is your localhost.
: make sure the mysql username above has privilege to write to the database_name, or just use the root user.
: When you import the file, make sure it's an intact mysql dump, meaning you don't open it and
相关阅读
讨论一下河南那个咬死人的蜱是怎么回事吧？有几篇中文文章，要不要写在CV里？Chinese journal finds 31% of submissions plagiarized (zz from Nature)申请奖学金把data写上去的话idea会不会被偷怎么找两个物种间的同源基因用Formalin fix过的细胞提RNA然后作microarray会有问题么？饶施的话题大家暂停吧投了一篇文章，4周时问，说没收到第二个review，现在5.5周再问的话，有人去过BioMidwest Career Fair吗？帮忙看看，这染的是啥部位和啥结构？多谢了关于皮下种瘤Conservation Biology Postdoc Fellowship ($50,000/yr)大鼠会不会很快取代小鼠成为第一模式动物？问俩技术问题--laser capture microscopy & microarray先不说他们的动机了，看下面他们有啥建议吧ma的文章不也被引了几百次？paper的第一作者问题Stand up to cancer show is live on...在线急问关于双酶切的问题有人讲讲MiRNA 在 stem cell 中的研究么？